In my project I have three tables. Bookings, Services and Customers. There is a New Booking form linked to the Bookings table. The First_Last Name column is ref’d to the First_Last Name column in the Customers table.
My question is how can I have the ‘Phone’ column in the Customers table auto populate a column in the Bookings table after First_Last Name is selected in the form?
Thanks in advance,