P
PC Datasheet
First, you need another table, InVoiceDetails. The invoice table should hold
the information about the Invoice as a whole such as CustomerID and Invoice
Date and the InvoiceDetails table should hold the information about the line
items, Qty, ProductID, Price, Discount and Extended Price. See the Northwind
example database for how the tables are designed. You then create a subform
based on the InvoiceDetails table and add the subform to the Invoice form.
Then you add the Invoice form to the Client form as a subform.
the information about the Invoice as a whole such as CustomerID and Invoice
Date and the InvoiceDetails table should hold the information about the line
items, Qty, ProductID, Price, Discount and Extended Price. See the Northwind
example database for how the tables are designed. You then create a subform
based on the InvoiceDetails table and add the subform to the Invoice form.
Then you add the Invoice form to the Client form as a subform.