In FMP 8.5, I have two globals - Company and Department (to use in a portal filter). I have a pop up Value list of Companies on the gCompany field, and want only the Departments from the selected Company to appear in the gDepartment Pop up value list.

I made a relationship gCompany Filter, with gCompany to Company and have the value list defined to include values from gCompany Filter::Department.

In a portal :gCompany Filter, the list of Departments change with each gCompany selected, but the value list does not change.

What am I not doing right?

Thanks

Stublito

Edited May 8, 200817 yr by Guest

I toyed around with a demo and couldn't figure out what the portal contains that needs global filters. In any case, here is a demo with a conditional value list. As you'll see, once you select a company on the Contacts form, you will only see the Departments that are available for that Company.

hth,

Barbara

Topic_195280.zip