In creating a new database I have a field "item number" that is related to the data database. The data database has individual records that include the item number and the item color.

In the new database I would like to have it drop down a value list of the colors of the particular item number entered.

I can get it to reference all the colors in the item color field as a value list but those colors are applicable to all item numbers. I'm wondering if it's possible to only pull up the colors that are the colors of the item number.

Thanks in advanced. This place is rapidly becoming my favorite place on the web.

Kukuberra

Can I just say, "nevermind." I figured it out. For those of you who may have this question it's a native function of FMP 5.5. There's a place when creating value lists where after you specify from a field in a different file you can also limit the field to related colors with in that file and it will go off the relationship you already have set up. Clear? Maybe not but it works!

Kukuberra