Order Data Table help

[Rednels]

Hello All,
I am new to access so this might be a stupid question but here goes.

I am making a new database for my orders (which I download from my eCommerce software in the form of a CSV file).

The Problem I am having is that my Order numbers are unique and that is what identifies the orders, however in the table data each order that has more than 1 item is listed on 2 seperate table lines. All info on the rows are identacle until the Part # field and the price field.

How can I make access understand that these few lines of data with the same order # are actually the same order with multiple items on the order?

Thanks,
Eddie

 

[David Eagar]

A starting point will be you need to store the data in 2 linked tables - an order table (order number, customer details etc) and an order lines table (linked order number, item, item price etc)
Search for Primary/Foreign key to get method of linking tables, as to the importing from csv into 2 tables, not sure, I can't recall ecer trying it, so hopefully some other kindly soul will help

 

[neileg]

I would:
Import the data into a table in Access in the form you already have it. Perhaps you may get away with a simple link to the data, it depends how it is structured.
Create two select queries. One extracts the order header details including the order number but set to unique values so you only get one record per order. The second extracts the order detail lines data, including the order number. This gives you a proper normalised structure.
Then, either work with the queries or append the data to two tables, depending on whether your import is the full set of data or just the new orders.