Any suggestions? (1 Viewer)

I've created a data base which list deliveries entering the company warehouse, each delivery may consist of 300 units.
At present I'm using combo boxes on a form to enter details such as job lot, purchaser and date which is the same for each job lot along with a description of each item.
My question is how do I enter a job lot, purchaser, date, etc once then enter 300 descriptions of each unit which it is associated with the job lot, the purchaser, date, etc must also be listed in a table which lists all fields.

If I understand you correctly you want two table:

tblPurchaser
JobLot (Primary Key)
Purchaser
Date
etc...

tblItems
ItemID (Primary Key)
JobLot (Foreign Key)
Description
Unit
etc...

Then create a form/subform with the Purchaser as the main form and the Items as the subform.

hth,
Jack