Only Sorted Items to show up in the List

[Leb i Sol]

Hi gang!

this one should be easy:

2 files (not related but can be if needed)

----file_1.fp5-----

[Name]

[Number] <--- value list to be use

-----------------

-----file_2.fp5--------

[Number]

[Available] (YES/NO)

------------------------

I have sorted/perfromed foundon file_2 based on "availability" and got an X number of records while the rest are omited.(ALL good so far)..now I want to your these "found" records ONLY in the value list for the file_1.fp5!

How?

thank you!

[Fitch]

In file_2, create a calculated field,

Case(Available="YES", Number).

Base the value list on the calc field.

[Leb i Sol]

great,thank you very much!