
Announcements
I have the following two columns in the SQL Server tables "name" (orange) and "name2" (yellow):
I want to "compare these two tables", such that I get the following display in a drop down as shown above:
- Names that are in name2 table AND in name table will be highlighted green.
- Names that are NOT in name2 table, but exist in name table, will be highlighted red.
- (there are duplicate names in name2, but there should not be duplicates in the drop down list)
How to achieve this?
In the Invisible property of the screen,
Sort(District(ClearCollect(coltable, nametable nametable2),namecolumn),Result)
coltable as the items of the dropdown.
You cannot highlite the individual items in a dropdown like in a gallery.