Associating Multiple Records
I am creating a quick search database for all of our invoices by exporting my sales journals from my accounting software. The interesting thing my accounting software does when it exports as .CSV is it makes every invoice line item its own record. So to give an example:
Record Cust_ID Invoice Description
1 ABC 123 Part# 321
2 ABC 123 Labor
3 ABC 123 Tax
So, when I query a particular invoice or customer ID, I come up with with a dozen or so records which are really just one invoice. Is there a way to have FM associate all records with the same invoice number as a single record?