Help please
I want to use a dropdown in a search form for a query
The dropdown needs to contain values from a peer related table e.g.
Customer table has a field Product. I want to search for Customers with Product X.
I would like to use a dropdown on the search form of the list of products in the Product table, then select Product X from the dropdown, and display the list in a presentation.
I get the dropdown field but it is grayed out and is inactive.
Any suggestions welcome. Thanks