Ok, i have a customer table, with customer details and a customer number, which is the primary key. I also have a bookings table, with a booking ref and a customer number in there too. I have a bookings form, where it comes up with selecting a seat to book, and then goes on to the customer form on a command button. On the customer form i need it to show all the fields in from the customer table, and the customer nuumber needs to be the maximum with one added on, e.g. customer number 10, new would be 11. Then i need it to go onto the confirming details form, where it shows the customer number, the booking ref, both new ones. The final form shows the fields that match the bookings table.
Can anyone help? Needs to be through queries/macros not code.
THanks
x
Can anyone help? Needs to be through queries/macros not code.
THanks
x