Inventory and Invoiveing- Followo for Steve Schapel

[Guest]

Hi Steve,

I did create an invoice table with feilds as :
InvoiceNumber (a code is used to generate invoice numbers)
primekey, CustomerName, and InvoiceDate. Another table,
tblTransaction, has PartNumber, PartDescription,
UnitsPrice(comes from another table), etc.

frmInvoice is continous and frmTransaction is now a
subfrom on frmInvoice. There is an error with duplicate
prime key. I guess my question is, whta must be the Prime
keys for these two tables? I have AutoNUmber as the
PrimKey to tblTransaction and InvoiceNUmber as the
PrimKey to tblInvoice.

Reards,

Mike