Thanks in advance for any help. So, I have a series of tables, let's say table1 through table5.
They are linked together via a field which is fine.
IN Table1, Table2, and Table3 if you run the report, there are 400 records. If I add Tables4 and Tables5 to the equation, there are only 300 records.
This is decreasing in record count because Table1 Table2 and Table 3 refer to the invoice and Table4 and Table5 tie to the purchase order. Not all invoices have a matching purchase order so it is isn't showing all the invoices.
I need to somehow formulate the linkage so that regardless, I still get 400 records. I only care about the data in the other two tables if there is a purchase order matched to the invoice.
Is there anyway I can do this?
IP Logged
