Jump to content
Sign in to follow this  

Two conditional value lists

Recommended Posts

reynir    0


FileMaker Advanced 11 question.

I have two separate conditional value lists in one layout showing Provinces, Districts and PostalOffices.

One shows the provinces in one country and is linked: Table1::OrginalProvince = Provinces::Province.

The Province table has following attributes: ID, Province, District and PostOffice

Then I have another conditional value list showing the Districts (with related values only)

And finally I have conditional value list showing the PostalOffices (with related values only). This works ok.

I used this method: http://www.teamdf.com/weetbicks/24/conditional-value-lists-pt-1-what-are-they-how-to-build-them 

My problem is that I want to have identical value lists showing the same attributes but with different relationships: Tabel1:DifferentProvince=Provinces::Province.

But when I make those conditional value lists the second conditional value lists seems to use the first relationship ??

So in the first conditons (dropdownlist) for OrginalProvince I select "Cabo Delgado" for OrginalProvince, then I get a list of districts for "Cabo Delgado" in OrginalDistricts (dropdownlist), when I choose "Balma" for OrginalDistricts then I get a list of OrginalPostalOffice (dropdownlist)

What happens in the second set of drop down list is that when I choose "Maputo" for DifferentProvince then I get a list of districts for "Cabo Delgado" in the DifferentDistricts (dropdownlist) ??

Any idea what is causing this behavior? I use two different relationships for the conditional value lists.





Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.