I'm trying to append and delete a single entry on a form from a button (user selects dispatched when the work is completed) but I keep getting errors referring to relationships on my tables. can someone take a look please and give me some pointers.
I'm trying to append and delete a single entry on a form from a button (user selects dispatched when the work is completed) but I keep getting errors referring to relationships on my tables. can someone take a look please and give me some pointers.
??? Have you considered a flag to indicate Dispatched, without deleting the record?
Perhaps you could describe the "business process(es)" involved so users can see your requirement in context.
When you get errors you're asking for help to avoid, post the error number and some/all of the message, otherwise we're guessing. Agree with Orange; flagging may be your only option unless you are trying to delete the one side of a one to many relationship and you have specified Cascade Delete. If you have not, then you will get an error. Keep in mind that should you get cascade delete to work, it will propagate throughout the tables, which may not be what you want.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thank you but I sat and worked it out.