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