Relationships

[123ashdwy]

I have three tables: customer, product and transaction.
Each customer can have many transactions and many products.
Each transaction can have many products.
I need to know how to relate this three tables so that each product can be bought by man customers and be seen in many transactions.

Also is there a way in Access to make a many to many relationshi??

Any suggestions??? Thanks!

 

[PHV]

Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

Once you understand table structures, open the sample Northwind.mdb. Look at the tables
Customers (customer),
Products (product) and
Orders and OrderDetails (transaction)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]