I have 3 text fields in a FM database... one is the users name, the other is their function (eg painter or plumber) and the other is the group (a letter reference eg A,B,C or D) that he/she belongs to.

Now what I want the main database to do is populate a drop down box based on a matching group reference - for example the main database records says this job belongs to "group a" and we are looking for "plumbers" only)... so I want a pull down list to only have group "a" members who have a function of "plumber" generated from the other database.

Is this possible?

Yes, it is!

Search in the earlier posts, there was something similar and someone posted an example, will certainly help you

Ahhh... Eastenders kind of gettin' sorted???

http://www.fmforums.com/threads/download.php?Number=144580

--sd

The only one I can find is where you create a value list from an external file using a related field... this gets me half way there, I then need to relate to a second field to kull the list further...

Is there anything like this that I can do?

Thanks for the reply,

That gives me the lists... but I really need the user to pick it from a dynamic value list for that particular record...

eg. from the pop up field display only names that have "plumber" as a function in the "functionfield" and a group equalling "A" in the "groupfield" from a second database...

Create a calculation text field in both files that is equal to Function & "_" & Group and a relationship between the fields. Base your value list on this relationship.