I have 3 forms:

Company Data>>Property Data>>Roof Section Data

Property Data is related to Company Data via company name lookup the Roof Section Data is related to Property Data via property name lookup.

I created a view based on Roof Section Data and have it filtered by company via the "Criteria" function. I'd like to create a drop down similar to the auto-filter in the below view and restrict the list to the properties belonging to the company name.

Is it possible to do something like this?

Thanks

arlan