How to load popup list based on criteria?

[kvt]

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

[BobWeaver]

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.

[kvt]

How do I define a relationship if I have more than one criteria?

For example:

F1.popuplist1=F2.a WHERE F1.b=F2.c AND F1.d=F2.e

where F1=file1, F2=file2 and a,b,c,d,e are define fields

[BobWeaver]

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.