HI all, I'm adjusting my DB to allow for an invoice line items table, however I also want an "already assigned warning dialog box".
In other words if a record (in this case an artwork) is already on an existing invoice you are given a dialog box asking if you want to cancel or reassign this artwork your new invoice (they are unique).
Attached is what I have so far.
I haven't been able to get the reassigned choice to remove from a previous invoice yet. It just creates a new.
Generally in a bit of a mess with it..
Hopefully it's clear what I'm trying to do.. any help would be great! Thank you...