I have a form to enter orders. It is displayed in a continuous format. The first field is a combobox based on a query to display a list of tickets per event: TicketId, TicketNo, Event, Date, Time. When a selection is done, the TicketNo is displayed but the value is the TicketId.
the other fields of the form are based on the Order table: TicketId, OrderNo, Customer, PaymentSatus, DeliveryStatus, etc... When a ticket is selected in the combobox, the ticketId of the form is changed accordingly (on lost focus of the combobox).
If I want to add a new record, the comboboxes of all the displayed records are blanked. When I select a TicketNo in the combobox of the new record (or any other record), it's value is displayed in the comboboxes of all the displayed records. Luckily, the information previously entered are not edited in the Order table. The problem is only with the display.
I don't know where to look anymore... :(