Ticketing project. Use of a sub-form? Multiple items on a ticket.

[detaylor1242]

I am trying to set up a simple form that the user can enter a ticket number and be able to input multiple items to be associated with the single ticket number. I have one table that contains the following fields. (TicketNo, ConsignorNo, Description, Qty, and Unit_Price).

I would like a single form that the ticket number is entered on and then multiple items can be entered in a tabular fashion.

Any help greatly appreciated.

[DubCap01]

Hi DeTaylor,

Where does the User get the ticket number from? Is it pre-assigned, or is it auto-assigned when entering the first of multiple items?
Is the ticket number derived from a separate table (TblTicketNumbers?) and the items added to a different table (TblTicketItems?)
One would hope so, but I don't think anyone can advise till you elaborate a little more

cheers
Pete

[NTC]

this is a core embedded feature of a 1:many relationship. You need a second table for Items. This Items table must have 1 field that cross references to your main table...maybe TicketNo if it is a unique value always in your main table and the primary key there...

make a form based on your new second table.

put your main form into design view, then inset your 2nd table form - the wizard will launch to trigger the linking.