Help with generating ID automatically.

[holzy]

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

 

[PNGBill]

When you say Customer Form do you mean "New Customer Data Entry Form"

If you want a form to enter data for a new customer then have a command button that selects the form in data entry mode and it should show all the fields you setup in the form (needs to be linked direct to the table) and may give you the new primary key or this will show as you enter data.

I just tested this...
Open the table in datasheet mode. select the form wizard and make a standard form (not continuous)
This will show all records with a record selector at the base that allows you to scroll through and or select the * to enter a new record.

select design view and data properties. No to edits, deletions and yes to additions and data entry and you should have a blank form to add a new record. The number will display once you start entering some data.