Dynamically Sorted Value List... is it possible?

[OPC]

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?

[TougToug]

Yes, it is!

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

[Søren Dyhr]

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

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

--sd

[OPC]

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?

[OPC]

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...

[-Queue-]

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.