Achieve Data

[brucey54]

Hi folks, I’m using Access 2007, I need to achieve some data from my database, what is the best way to do this.

I have a one to many relationship database, so 1 customer could have many orders, how would you achieve this data? Open to ideas....

 

[jdraw]

There are several free data models at Databaseanswers.org.
Here is one that may help you. Customers and Orders data model

You might also find these steps re database design helpful.