Hi everybody
I have three table, one table has a enumlist column like this:
LOCATION | NAMES |
STAGE 1, STAGE 2 | JOHN |
STAGE 2 | MARIA |
STAGE 1 | PAUL |
The second table:
ID | LOCATION |
sh334 | STAGE 1 |
gsf45 | STAGE 2 |
hsh3hj | STAGE 3 |
In the third table I have a enumlist to select NAMES, but I would like display only the NAMES according to their LOCATION.
for instance, If I select in table 3 ref column( from second table) LOCATION = STAGE 1 only display JOHN and PAUL (enumlist) to select
LOCATION | ENUMLIST |
STAGE 1 | PAUL, JOHN |
I have tried in suggestion value and valid if but I have problem with text and list
Thanks
Solved! Go to Solution.
In the "Table 3" EnumList column in Initial Value property, you would use an expression like this:
SELECT(Table 1[Names], IN([_THISROW].[Location], [Locations]))
Set the Valid_IF expression to this expression which sets the list of possible names to choose from:
Table1[Names]
When you apply the above and then enter a new row in Table 3, the names will initially be set to those from Table 1 but you will have the option to modify the list of names if you wish.
In the "Table 3" EnumList column in Initial Value property, you would use an expression like this:
SELECT(Table 1[Names], IN([_THISROW].[Location], [Locations]))
Set the Valid_IF expression to this expression which sets the list of possible names to choose from:
Table1[Names]
When you apply the above and then enter a new row in Table 3, the names will initially be set to those from Table 1 but you will have the option to modify the list of names if you wish.
Hi @WillowMobileSys thanks!
I made a little change
this expression in valid_if
SELECT(Table 1[Names], IN([_THISROW].[Location], [Locations]))
and this in Suggested values
Table1[Names]
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |