LinkedIn
Twitter
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:
Select_Asset_Type
Select_Cabinet_To_Survey
To generate a drop-down list in the form and populate a 3rd column in the Survey table below:
Asset_Name
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… 
Solved
1 ACCEPTED SOLUTION
Hi @Suvrutt_Gurjar,
Thank you for your very prompt response.
I had looked at UNIQUE() and and a number of other functions before but it is only now that I see how you’ve applied it that it makes sense. The use of “+” is also a revelation to me and I now see how to sensibly join two expressions together!
Your offer does exactly what I asked for! Many thanks… 
Solved!
SORT( UNIQUE(SELECT(RF_Design_Assets[RFdesign_SOURCE_Asset_Name], AND([_THISROW].[Select_Asset_Type]=[RFdesign_SOURCE_Asset_Type], [RFdesign_Main_Asset] = [_THISROW].[Select_Cabinet_To_Survey])) + SELECT(RF_Design_Assets[RFdesign_DESTINATION_Asset_Name], AND([_THISROW].[Select_Asset_Type]=[RFdesign_SOURCE_Asset_Type], [RFdesign_Main_Asset] = [_THISROW].[Select_Cabinet_To_Survey]))), TRUE)
