Hi
I have a form for booking tickets for events.
I have a table of Events, a table of Attendees and a link table of Event-Bookings which uses the Event_ID and the Attendee_ID to records the quantity, type of ticket and ticket number etc.
My main form is based on the table of events and the sub form is based on a query.
I am having problems making ticket number field use the next sequential number for each particular event.
Please can anyone help?
I have a form for booking tickets for events.
I have a table of Events, a table of Attendees and a link table of Event-Bookings which uses the Event_ID and the Attendee_ID to records the quantity, type of ticket and ticket number etc.
My main form is based on the table of events and the sub form is based on a query.
I am having problems making ticket number field use the next sequential number for each particular event.
Please can anyone help?