Jump to content

How to load popup list based on criteria?


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

Recommended Posts

Hello,

I have two popup fields that retrieve values from a second file. On one field I want to retrieve list of names that is of type X and on the second field I want to retrieve list of names that is of type Y. Where name and type fields are define fields on the second file.

I used the define value list to get the data from the second file for each of the popup field, but don't know how or where to put the criteria so that it only load the list for type X on one field and type Y for the second. Does anyone have any idea or is there another approach?

Thanks

kvt

Link to comment
Share on other sites

You probably want to define the value list to use related values, and then set up a relationship to the second file using the criteria you want to select the values. There's a much more detailed description how to do this in the FM user manual.

Link to comment
Share on other sites

  • 2 weeks later...

You need to make a compound key field in each file. In File 1, make a calculated field "Key1" with the formula:

B & "-" & D

and a calculated field "Key2" in File2 with the formula:

C & "-" & E

Then set up the relationship using the fields Key1 and Key2.

Link to comment
Share on other sites

This topic is 7570 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.