a field of a record has more than one record in access table

[Guest]

eg. purchase order table:I have one record for each order,but some orders
have more than one item ,how to arrange my table so that I should not repeate
the order number for each item specially when the order number is primary key.

Thank you very much for your help.

 

[Dorothy]

eg. purchase order table:I have one record for each order,but some orders
have more than one item ,how to arrange my table so that I should not repeate
the order number for each item specially when the order number is primary key.

Thank you very much for your help.

Hello. I think the best way to do this would be to have a separate
table for just orders - say tblOrders. Make the order number in this
new table a primary key so that each order number is unique.

You can then build a relationship to this table from the purchase
order table so that they link on the order number by going to "Tools"
then "Relationships".

Good luck!

Dorothy
(e-mail address removed)

 

[Allen Browne]

You need a related table for the line items in the purchase order.

For an example, open the Northwind sample database that installs with
Access. Open the Relationships window. See how the Orders and Order Details
tables are connected. That's the approach you need to take.

 

[Guest]

The problem solved by your help, so thank you very much. Thanks also to every
body how participated on this question - answer programme.
abosamra