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.