Creating table for Sales Ticket Validation

[detaylor1242]

I have a table consisting of TicketNo, Consignor, Quantity, UnitPrice and UnitTotal . The UnitTotal is a calculated field.



I need a input form that at the top of the form I would put in the ticket number and in the bottom of the form I would input all of the items sold on that ticket. Once the ticket is completed. It will calculate the Sales Tax at .087 and at Total for the ticket. The data entry operation is not done at sale time but usually a day later. The input to this form will allow the person entering the data to validate that the ticket was charged out properly.

There are 6 reports that use this information.

Thanks for any help provided. If you have a sample form that would also be great.

The original ticket are typical sales form books from Office Depot. They are pre numbered. Typically we use 500 to 600 tickets for our annual sale.

[June7]

What is your db structure?

Do you have Tickets and TicketDetails tables? Build a form/subform, main form bound to Tickets and subform bound to TicketDetails. I think what you call Ticket is synonymous with Invoice.