I have a database where the main table where all the information gets added in.
There are alot of fields which will open a selection box where you could select a technician. There is another tabel where we can add new technicians. But when a technician is deleted (left the company) the information gets stripped out from the main database too.
Is there a way to stop this from happening? I have about 15 other fields that have the same setup.