Using a values list from another file

[EllenG]

This should be easy and I looked on the forum, but could not find an answer...

I have the following:

Valueslist::Species

Valueslist::Category

Valueslist::Value

I need to setup values lists that are accessible to other files, so that a global field with Species will only list categories for that species and a selected category (as a global field or calc field) will list only associated values. "All" will be valid for Species (but the global field for Species will have an actual species indicated.)

I tried to set up a simple one, using just the category and values fields, but can't get it to work:

The Category is Contact and the values are contact types, such as employee, accountant, supplier, etc. I want the list of values for Category Contact to be accessible in my Contacts file to field Contacts::Type.

I created a self-join relationship in the Valueslist file called ContactType using a calculated field; Constant_Contact = "Contact" (indexed) to match to Valueslist::Category (this one does not use the Species field.)

I created a values list in the Valueslist file:

Use values from field ContactType::Values, using only related values starting from Valueslist

It works fine and I get the correct values in the drop-down list. However, when I try to use the ContactType values list in the Contacts file, it doesn't work.

I created a relationship in the Contacts file to ValuesList using a calc filed Constant_1 match and created a values list in the Contacts file for ContactType to:

Use values list from another file: Valueslist

Values list: ContactType

When I set the Contacts::Contact filed to use that values list, nothing shows up (no list pops up.)

I tried several different ways to do this and can't get it to work.

I can't figure out what I am doing wrong.

Using species would work something like this:

A user may have several animal types such as goat, sheep, alpacas. When in the Herd file, the current species will be in a global field, Herd::Species_g. One of the valueslist categories is Location. So, for the Herd::Location field, I would want the drop-down list to only show the Valueslist::Values for

Species=Herd::Species_g and Category = Location...probably a calc field using Get(CurrentField)??

However, the user may not have separate locations by secies, so I want the value "All" in Valueslist::Species to be selected regardless of the value in Herd::Species_g.

Hope this makes sense!!

BTW, I used FMP6 for years, but am new to FMP10, so muddling my way through. Have a huge application I am converting and running into these issues is really slowing me down; but excited about the new capabilities.

Thanks.

[EllenG]

Well, I didn't get any replies, but that's OK... I figured it out!