Hi

I have a lookup in a subform that i want to filter based on a lookup selection in the main form. how to do this?

e.g

Main form i have a dropdown called Customer - based on the customer selected, in subform, i want to show only products pertaining to that customer.

I did a set_filter for the lookup in the subform:

Customer == Main.Customer

This doesn't work. If i hardcode a value,

Customer == "abc"

it filters correctly and shows