I have drop downs using 2 different tables connected by a key in each table. For simple problem say
Table1 has these columns
Officename, City, Countyid
Table2 has these columns
Countyid, Countyname, State
Countyid is a unique value
So I need the default in dropdown2 to show the Countyname based on the officename selected in dropdown1.
That is perfect thank you very much.
In that case you could leave the Items property simply as:
Table2
To change the default selection, we will need to add the following code to the Default property of your second dropdown:
LookUp(
Table2,
Dropdown1.Selected.Countryid = Countryid
).Countyname
In order for this to work, make sure that Countyname is the field being displayed within your second dropdown.
I hope this helps!
Yes, that does the cascading when I put the filter in the items like you described. So that is a step in the right direction for me. When I change dropdown1 it does put the proper value in dropdown2 but what if I still wanted all the items available from table2 to be listed but only the default changed.
Hi @Memtiger,
You would have to filter the datasource mentioned in DropDown2's Items property. The code will look similar to:
Filter(
Table2,
IsBlank(Dropdown1.Selected) || Dropdown1.Selected.Countryid = Countryid
)
//If you only want the Countyname, you could append the filter with .Countyname
If this solves your question, would you be so kind as to accept it as a solution.
Thanks!
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1