dinamical value list

[Raybaudi]

Hi, friends

I have a value list based on a field contents.

How can I dinamically have the list shown only the values of the found set, after a "find" based on another field of the same record ?

[comment]

There is no way (that I know of) to base a value list directly on the found set.

Since it seems you have the Find scripted, you could use the same script to turn the found set into a related set. The easiest way would probably be copying all found RecordIDs into a global.

Alternatively, copy the values you need and paste them into a non-global field in the users table.

[sbg2]

Import the found set into a related table, similar example shown in the following thread:

http://fmforums.com/forum/showtopic.php?tid/168231/post/169249

You may want to make the relation field a bit more unique such as:

Get(CurrentHostTimestamp) & Get(UserName)

I would also suggest deleting the related records once the user is done with the search.

[Raybaudi]

Thanks boys.

I hoped there was a more directed method ...

but your indications have been equally precious.

[sbg2]

It would depend on how complex the find was. In the attached example running the Find Script and entering a single date will produce a list of Companies that have a corresponding Requested Ship Date (Value List attached to Company_VL field). If you wanted a range of dates it would be a little more complex, but still workable.

The more complex the possible find the more complex it would be to create the dynamic value list.

Not sure if that helps any.

VL_FromFoundSet.zip

Edited July 28, 2005 by Guest

[SlimJim]

I was interested in your example and this thread as I have recently been experimenting with using a global "pinch table" to pull out subsets of data much like found sets. I have no doubt that this has been done before but I'll post an example anyway. I have taken the VL_FromFoundSet file of the previous poster and made a few alterations.

GlobalPinchFile.zip