r.m.c Posted December 5, 2001 Share Posted December 5, 2001 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? Link to comment Share on other sites More sharing options...
Kurt Knippel Posted December 5, 2001 Share Posted December 5, 2001 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8198 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now