Customer database problem

[paasan]

Hi!

I'm making a customer database and I need it to show me what products the customer has bought. How can I make it work so that I could add the product that the customer bought to a list where i could see all the bought products?

I got two tables one is the customer info table and the other is the product list table.

Thanks for the help!

[orange]

You need to get your tables and relationships set up.
There are existing data models at
http://www.databaseanswers.org/data_models/index.htm

You may want review the Tables and relationships in the Customers and Products sample at
http://www.databaseanswers.org/data_...ucts/index.htm

and the Customers and Orders example at
http://www.databaseanswers.org/data_...ders/index.htm

This may be helpful to you also.
http://www.databaseanswers.org/approach2db_design.htm

[RuralGuy]

And don't forget to look at the Northwind sample that is shipped with MS Access.