I want to book a customer into a training course.
I want my Booking Input Form to get all the customer information from the Customers table as soon as I enter the Customer Number.
Once the form auto populates, I add the start and end date. Then I want all the info in the form (Customer and dates) to go to a Bookings table.
The Customers table exists and has good data and I have a blank Bookings table ready to receive a booking.
How do I get my form to fetch most of its data from the Customers table?
Thanks - rev