Value list from unstored calculated field

[r.m.c]

Okay.. i really tried this time

Let's go...

I amusing a Join file for Contact and Organization. (Yes each contact may have 0 to many related Org's and each Org may have 0-many contacts.)

Within this join file I have a calculated field "Contact_Name" so I can view all contacts within the Organization file for each org.

I want to set a main contact within Org based on a list of all the contacts related to the Organization. 'main-contact' is a field in Organization.

I want to use a value list to choose the contact name.

Organization and Contact are only related through the join file.

FM Pro does not allow values lists created through a relation based on the 'unstored' calculation of "contact_name"..

Any thoughts?

[Kurt Knippel]

You could create the value list in the Org file (which will be using the stored ContactID to create the list), and then use that value list in another file.