organizing import data for display

[wezel99]

Hi, I am receiving this file from a supplier to import as a table. The issue is I cant figure out a good way to display the info for each invoice because there are multiple rows corresponding to each invoice number. I wanted to build some type of form where I could search an invoice number and it would pull up the standard invoice format to print such as inv.#, mailing address, linedesc amount and costs of shipping each item. I cant figure out how to get the invoices that have multiple line items to display in a nice format though.,,

 

[pbaldy]

I would import the data into 2 tables, order header and order detail. One record per invoice in the header, a record for each item in the detail. That would be the normalized way to store invoice data. You should be able to do it with append queries based on the spreadsheet, the first only getting distinct values.

 

[wezel99]

this was spot on, thank you.

 

[pbaldy]

Happy to help!