I've been trying to figure out how to do this but since I'm not familiar with Access terminology, it's proving to be difficult.
I will attach my database to this post, but the general setup of my database is as follows:
I need to have a form setup to add records to each table. Creating these for Mechanics & Customers went very smoothly, but figuring out how to display something other than the "id"'s when adding an Appointments record did not. To clarify, I would like to see the Customer/Mechanic's forename and surname instead of their "id" when using the form labelled "Appointments Form".
Thank you!
I will attach my database to this post, but the general setup of my database is as follows:
- I have 3 tables; Mechanics, Customers & Appointments.
- Each has an AutoNumber primary key called "id".
- The Appointments table has "mechanic" & "customer" fields that reference the "id" fields from the other two tables.
I need to have a form setup to add records to each table. Creating these for Mechanics & Customers went very smoothly, but figuring out how to display something other than the "id"'s when adding an Appointments record did not. To clarify, I would like to see the Customer/Mechanic's forename and surname instead of their "id" when using the form labelled "Appointments Form".
Thank you!