Jump to content

Dynamically Sorted Value List... is it possible?


OPC

This topic is 6995 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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?

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6995 days old. Please don't post here. Open a new topic instead.

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
×
×
  • Create New...

Important Information

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