Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with relationships linking

Status
Not open for further replies.

eddrimmer

Technical User
Jan 27, 2004
4
GB
Hi

My database for a computer shop will hold details of a sale.

I have a sales table which has: SalesID, CustomerID and StaffID. I need to have details of what the customer buys in another table called SalesDetails, but am not sure what relationships I will need? Ive been told the Sales table will ink its SalesID to SalesID in the SalesDetails table, and then have a Sale_Item field which will contain the StockID of the item. I will then be able to look up which items go with which SalesID, is this correct? Im just not sure about the linking.

Thanks
Edd
 
Take a look at this article. It often helps out folks in your shoes:
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top