I have a list of suppliers where I have all their information, what I want is that only my assets appear on my main page and when their provider date expires I can remove them from my list of providers without needing to delete them from my database of data.
All you have to do is add a field called for example "status". If the state is at 0 (zero), it is inactive, if it is at 1 (one), it is active, and you generate a query to only allow those that are in state 1 to enter. Regards
(Edited) If it's in SQL, you can do this. In this way you bring all the suppliers that are in state 1 (activated). I repeat, as you do not indicate which database engine you use, it is difficult to say exactly how to solve it, but I think you could do it that way.
SELECT * FROM proovedores WHERE proovedores.estado = 1;