How do you record multiple values into a column??

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

re: How do you record multiple values into a column??

graycam@gmail.com wrote:[color=blue]
> 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?[/color]

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

re: How do you record multiple values into a column??

you need
tblSales
salesId
custId

tblSalesDetail
salesId
prodId

to allow for many products for one sales order

graycam@gmail.com wrote:[color=blue]
> 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[/color]