Multiple records for same client

[aymanmb]

I want to create tables with clients and another table to populate multiple orders for each client. How these tables will look like and how to create one to multiple relationship.

thanks

[June7]

Consider a very simple structure:

tblClients
ClientID
LastName
FirstName
Address
Phone

tblProducts
ProductID
ProductDesc
ProductPrice

tblOrders
OrderID
OderDate
ClientID

tblOrderDetails
OrderID
ProductID
Quantity

[orange]

There are a number of free videos to explain and develop such a database in my post at
https://www.accessforums.net/databas...d-35234.html#3