Topic: Prevent a record from being Deleted?
Hi folks,
If I put a record in a table can I make it permanent and prevent the user from deleting it?
.
I have a Supplier table where the user can add and remove suppliers as needed. But I would like to have one record with the name Unknown so it's always there.
.
It would also be nice when adding a new Equipment record that the Supplier Name shows Unknown shows up automatically, then the user can click on the combo box and choose a different supplier from the supplier table if they want.
.
There will be times where the user will not have a Supplier Name.
However if they leave the field BLANK, then I'm having trouble later on in reports.
-------------------------------------------------
UPDATE:
Here's what I did:
I created a SUPPLIER record with the name = - Unknown -
So when the combo box is sorted this entry comes up at the top of the list.
Then I found DefaultIndex = 0, so I changed it to DefaultIndex = 1
Now when I'm creating a new Equipment record the combo box for SUPPLIER defaults to - Unknown -
This means no more blank combo box fields. And I can now use this record in reports.
.
So it seems like this technique solves my empty field problem.
However, my first question still remains. How do I protect this record and not let the user delete it from the SUPPLIER table?
.
Thanks
Frank