Solved: How can limit list of 'Ref' type fields?

Oran_M · 07-13-2021 01:33 AM

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].

Steve

View solution in original post

Lucinda_Mason

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.

Oran_M

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.

Lucinda_Mason

Both fields are REF type.

Steve