My situation is as follows:
- Customer List
- Reply List
My reply list has a lookup field to the customer name in the customer list.
What I want to do is to be able to filter on a customer name (the lookup column) and then create another filter on a field (country for example) which resides in the customer list. So in theory the user should be able to see related fields within the reply list from the look up field's list (customers).
So the fields in the reply list would be like this:
Title - Customer Name (look up) - Category - Customer's Country (related field) - Reply Date
