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
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