Unanswered: Howto display lookup value in a text box?
I'm trying the following:
I have a Passenger table with names (PassengerID, First name, Last name, etc.)
I have another table with Cars. (CarID, Licence plate, etc.)
A third table, called Travels contains Car IDs and 4 Passenger IDs - Who travelled in which car (TravelID, Date, CarID, Pass1ID, Pass2ID, Pass3ID, Pass4ID)
Passengers.PassengerID has one-to-many relationships with Travels.Pass1ID, Pass2ID, Pass3ID, Pass4ID, since one passenger can make several trips.
I want to show display data on a form like this:
Travel1 - Date, Car, Passenger1 full name, Passenger2 full name, etc.
Travel2 - Date, Car, Passenger1 full name, Passenger2 full name, etc.
I can do it with combo boxes, but I don't want to have the little drop-down arrow on the right of the box. That's why I'm trying to use text boxes. Any hint how to implement this?