How do you record multiple values into a column??

[graycam]

E.G. I want to record sales.
Three tables - TblProduct TblCust & TblSales

TblCust fields = custID custName
TblProducts fields = prodID prodName
TblSales fields = salesID custID prodID

If Bob (cust ID 555) buys prodID 4 and prodID 5, how can I record this
in TblSales? Can I record both item 4 and 5 in a single field?

EG
salesID = 100
custID = 555
prodID = 4 & 5

or would I need:
salesID = 100
custID = 555
prodID1 = 0
prodID2 = 0
prodID3 = 0
prodID4 = 1
prodID5 = 1

What's the normal way to do this?

Thanks!
Cam

[Rick Brandt]

gr*****@gmail.com wrote:

E.G. I want to record sales.
Three tables - TblProduct TblCust & TblSales

TblCust fields = custID custName
TblProducts fields = prodID prodName
TblSales fields = salesID custID prodID

If Bob (cust ID 555) buys prodID 4 and prodID 5, how can I record this
in TblSales? Can I record both item 4 and 5 in a single field?

EG
salesID = 100
custID = 555
prodID = 4 & 5

or would I need:
salesID = 100
custID = 555
prodID1 = 0
prodID2 = 0
prodID3 = 0
prodID4 = 1
prodID5 = 1

What's the normal way to do this?

The normal way is to have an additional table for the items on each sale.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[lesperancer]

you need
tblSales
salesId
custId

tblSalesDetail
salesId
prodId

to allow for many products for one sales order

gr*****@gmail.com wrote:

E.G. I want to record sales.
Three tables - TblProduct TblCust & TblSales

TblCust fields = custID custName
TblProducts fields = prodID prodName
TblSales fields = salesID custID prodID

If Bob (cust ID 555) buys prodID 4 and prodID 5, how can I record this
in TblSales? Can I record both item 4 and 5 in a single field?

EG
salesID = 100
custID = 555
prodID = 4 & 5

or would I need:
salesID = 100
custID = 555
prodID1 = 0
prodID2 = 0
prodID3 = 0
prodID4 = 1
prodID5 = 1

What's the normal way to do this?

Thanks!
Cam