When Field with โRefโ type shows dropdown list from related table, how to limit the list for certain value or condition set by another Field ? for example, I need a list of Benzene Oil for Benzene car and Deisel Oil for Deisel Car from table [Fuel] for โRefโ [_THIS].[FuelID] after selecting โRefโ [_THIS].[Car] which contains [Fuel].[FuelType] = [_THIS].[Car].[CarFuelType].
Solved! Go to Solution.
This is part of a more complex expression but works.It selects Team based on Teams under the selected Department, which is also Ref field.
In the ValidIf for Team:
SELECT(TEAM[TEAM_NO],AND([DPT_NO]=[_THISROW].[DPT_NO]))
Note: I just quickly pulled it out of the much more complex expression. I think the closing parenthesis are correct but havenโt tested.
I found the same solution so far, but the field has to be set in โTextโ.
But โRefโ is really useful for further reference in other UXs, in my opinion.
Iโll update again when I can have it
Anyway, thank you so much for your reply.
Both fields are REF type.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |