Possible to filter list based on field 1, but display only field 2?

[fmphysio]

I'm wondering if it's possible to filter a value list that has two fields specified.

Example:

ID & Info

Is it possible to filter this value list, based on the ID, but display Info, for example in a calculation.

I am using the following to filter the list:

FilterValues(ID; ValueListItems(Get(FileName);"Valuelist 1"))

This filters it correctly, but displays the ID, when I would like it to show the Info instead.

Also, is it possible to remove the carriage return at the end of the filtered result?

Thanks heaps.

[LaurenKuhlman]

I would actually do this with a relationship...

Essentially, create another table occurrence for your table that has the ID and Info fields in it. Draw a relationship based on your ID field. Then, create a value list where you use values from the new table occurrence and the info field. Choose include only related values starting from the table on the left hand side of the relationship.

I attached a VERY bare bones sample file that should help. Let me know if you need any help. Or, if this helps let us know.

: )

Relational_Value_Lists.fp7.zip

Edited December 10, 2009 by Guest