I have 2 tables , one is ORDER and another for INVOICE. Once an order is invoiced, the lines in the "Invoice" Table replaces the lines in the "Order" Table.
However i want to look at orders that are not invoiced at all, hence I have combined the 2 tables , by concatenating the "Order" table to the "Invoice" table and thereafter dropping the "Orders" table as shown below.
Concatenate ([INVOICE])
Load * Resident [ORDER];
drop table [ORDER];
When an order is invoiced , it generates an invoice number, otherwise invoice number its shown as "****NEW***.
When an item in the order is fully invoiced, the line in the order table is replaced with the line in the invoice table.
However if an item is partially invoiced or not invoiced, then same item appears twice.
I only want to show the line that appears in the invoice table and the line in the order table to fall off.
How do i do this in the scripting.
See attached excel . Those lines that are highlighted I want them to fall away.
Just one query, the actual data that i am working on, the ORDNUMBER and ITEM are in two seperate tables. They have a common link field called UNIQINV. How do I apply this in the scripting you have given me.
