Topic: Referential integrity
Hello,
I have a table of service jobs and another table of customers. When I make a new service job, I have a combo box on the job form where I select the customer and that works fine. If I delete the customer from the customer table, it asks me for confirmation and if I allow the deletion, it will delete the customer record even if I have a service job with that customer name on it. The combo box in the service job form then becomes blank (no customer name). I have the customer table set as a dictionary.
I am pretty sure that in a previous version, if I deleted a customer where there is a service job existing with that customer name on it, the software would prevent me from deleting the customer. That is how I would like it to work.
If I change the customer name, the name change is shown in the service job as expected.
Is it possible to prevent customer deletion in the situation I have described.
Thanks for any help,
David