Forum Discussion

ldbrassard's avatar
ldbrassard
Qrew Member
12 days ago

Airports related to hotels

Good afternoon, 
Still learning QB and I need help with conditional formatting.  I have a list of airport codes and each airport has one hotel or multiple hotels related to that city. 
When an user selects the airport they want too, I want the hotel field to provide all the hotels related that city. I have been struggling with issue for a while now. 
Thank you for all the help. 

  • Yes, that can be done with a Conditional Drop Down setup, sometimes called CDD.

    Presumably you already have a table of Airports.

    You will need a Table called say Airport Hotels similar to your attached CSV file, but with the Airport Code filled in for every record.

    Then your form will pull in the hotel name from a relationship lookup from the Airport Hotels table.

    On the field for Related Airport Hotel, you will go to the field properties and set the conditional checkbox, and set it so that once you select the airport code on your "Traveller" record, it will limit the Hotels choices to just the Airport Hotels for that Airport code on the Traveller record.