I think you mean "tables" when you say "databases".
And where does this cause a proble?. If there are no invoices for a given work order, the portal to invoices will be empty.
Yes, I do mean "Tables".
Currently, they only way I can find out if a "Work Order" is missing an Invoice, is to go one by one. That will take a while with over 5000 records. I was hoping to make a script or something.
Put a copy of JobID from invoices on your work orders layout.
Enter find mode
Put a lone asterisk (*) in that field.
click the Omit button in the status area tool bar.
Perform the find
This will find all WorkOrders that do not have at least one related invoices record.
This can also be performed in a script--and in which case, you won't need to place the Invoices::JobID field on your layout to do so.
After all the stuff I tried, I never tried that. Thank you. worked great.