Auto input data in a field in a form using relationships

[18khattaba]

I have two tables and one is for customers and the other is for prices of hotels. For every location, there is one hotel. In the customers form, I wold like it to auto select the hotel when the user selects a location. I would like to do this using relationships.

[Bob Fitz]

I have two tables and one is for customers and the other is for prices of hotels. For every location, there is one hotel. In the customers form, I wold like it to auto select the hotel when the user selects a location. I would like to do this using relationships.

Cross posted: https://www.access-programmers.co.uk...nships.326199/


Please read: https://excelguru.ca/a-message-to-forum-cross-posters/

[Welshgasman]

Use a combobox and bring in the Location and Hotel.
When a combo item is selected, set the Hotel from that row.
Combos start at 0.

[June7]

So selecting location selects hotel?

Combobox can have a RowSource that displays both location and hotel info.

SELECT ID, Location & " : " & Hotel AS LocHot FROM Hotels;

Bind combobox to field you want to save the ID into.