Hi
I have a set of forms connected to my tables.
Currently i let users remove records.
But id like to stop that and instead find a way to hide or deactivate the records instead of running the delete command.
Does access support something like this?
Or do i have to build something?
If i have to build something... im thinking of having a archive table for every table i create and move records to them instead of deleting... but this will be quite messy i believe....
any ideas on how to do this?
another idea is to create a column that gets an value "INACTIVE" and then i need to filter everything i do so those records are not shown... but i have no clue if this is doable or how i should approach it.
I have a set of forms connected to my tables.
Currently i let users remove records.
But id like to stop that and instead find a way to hide or deactivate the records instead of running the delete command.
Does access support something like this?
Or do i have to build something?
If i have to build something... im thinking of having a archive table for every table i create and move records to them instead of deleting... but this will be quite messy i believe....
any ideas on how to do this?
another idea is to create a column that gets an value "INACTIVE" and then i need to filter everything i do so those records are not shown... but i have no clue if this is doable or how i should approach it.