Question: Is it possible to generate a drop-down list of unique results using data that sits in two different columns?
This one is bending my head… I have it working on one column but can’t figure out how to use it on two columns at once?
I have a table = RF_Design_Assets
It has a column with asset names = RFdesign_SOURCE_Asset_Name
And a second column with different asset names = RFdesign_DESTINATION_Asset_Name
There is also a ‘category’ column = RFdesign_Main_Asset
I have a form that uses a combination of the above and two columns in another table = Survey:
To generate a drop-down list in the form and populate a 3rd column in the Survey table below:
Asset_Name uses the following expression:
SORT(SELECT(RF_Design_Assets[RFdesign_SOURCE_Asset_Name], AND([_THISROW].[Select_Asset_Type]=[RFdesign_SOURCE_Asset_Type], [RFdesign_Main_Asset] = [Select_Cabinet_To_Survey]))[,Yes])
This expression works but the resulting drop-down list excludes items from column RFdesign_DESTINATION_Asset_Name
I hope this makes sense? Thanks in advance… Cheers…