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

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

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]