AnsweredAssumed Answered

Cross Referencing

Question asked by CraigFiore on Dec 11, 2012
Latest reply on Dec 11, 2012 by CraigFiore


Cross Referencing


     Hello there,

     I am looking for help to cross reference two data bases. I hope I can explain this clearly.

     I have two data bases, "Work Orders" & "Invoicing". Within Work Orders I have a portal to view Invoicing. The two are connected by a field called "JobID".

     The reason I have two different data bases is because I may have up to 15 different invoices for one Work Order.

     I am try to find out a way to see if there is at lease one "Invoice" file for every "Work Order" file.


     Thank you,