Let's say for example I have a customer table:
customer { customerid, firstname, lastname, address, phone }
customerid is a key field.
and a reservation table:
reservation { reservationid, customerid, apartmentid, arrivaldate, departuredate }
reservationid, customerid, and apartmentid are key fields.
reservationid is auto-incremented, customerid is the id of the customer making the reservation, apartmentid is the id of the apartment being rented (there's another table for that, which isn't really relevant here).
In the relationships customerid from the reservation table is linked to customerid from the customer table.
(this is just an example, btw)
So say I make a form out of the reservation table. On it I have a customerid field, which shows the number. What I want to do is instead of having the field simply show the customer's id (which isn't very helpful for the user who wants to enter the customer in there), I want it to be a drop-down combobox showing a list of all customers' first and last names, from which the user can select a customer.
So it basically displays the firstname and lastname but in the background stores it as the customerid.
Hopefully that made sense, if not just let me know, and hopefully CookieRevised sees this post too.
