AndrewJudd

Invoice line items with already assigned

Discussion created by AndrewJudd on Sep 12, 2015
Latest reply on Sep 15, 2015 by AndrewJudd

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...

 

 

 

Screen Shot 2015-09-12 at 11.25.59.png

 

 

Screen Shot 2015-09-12 at 11.23.13.png

Outcomes