Hi, all. So, I have a form with a record for each client. And when I use the record selector to delete a client, the client's record initially disappears just as I would expect. But, when I close the form and reopen it, the client's record is back. So, it was not deleted after all.
I suspect it has something to do with the fact that the form's record source includes the parent table tblClientInfo, as well as a related child table, tblNext.
But I still don't know how to fix the problem. I want to make it so that deleting the record actually deletes the client, and cascade deletes data in all child tables.
I've attached the db. The form in question automatically opens at startup. Please let me know how to fix. Thank you!!
Dom's Database Revision.zip