ron G Posted March 26, 2011 Share Posted March 26, 2011 I am using FM 11ADV I have been wrestling with this perplexing problem. (Please see relationship diagram below) The layout is based on Meetings (Yellow) On the Meetings layout, there are 2 tabs. The First Tab is named Members and has a portal based on MemberMeeting Join and it works. There is also a Members 2 valuelist based on Members 2. MemberMeeting Join::MemberName uses that value list. THIS WORKS. But, the identical setup (in gray), does NOT work. I get a single Visitor Name when I use the value list just like the one I use with Members 2. huh? Is my FM datbase corrupted? Or, (more likely) "What am I missing???" Thanks for reading. Link to comment Share on other sites More sharing options...
comment Posted March 26, 2011 Share Posted March 26, 2011 Why don't you post a file showing the problem? It would save endless questions like 'have you done this' or 'have you done that'. Link to comment Share on other sites More sharing options...
ron G Posted March 26, 2011 Author Share Posted March 26, 2011 OK. Here is the Membership.fm7 file.... Thanks for your help. MembershipXX.fp7.zip Link to comment Share on other sites More sharing options...
bruceR Posted March 26, 2011 Share Posted March 26, 2011 OK. Here is the Membership.fm7 file.... Thanks for your help. Why would you relate visitors to meetings by visitor ID instead of meeting ID? Link to comment Share on other sites More sharing options...
ron G Posted March 26, 2011 Author Share Posted March 26, 2011 Why would you relate visitors to meetings by visitor ID instead of meeting ID? I 'think' this is what you meant? If so, it didn't work. Same problem. Just shows one Visitor in the ValueList... I 'think' this is what you meant? If so, it didn't work. Same problem. Just shows one Visitor in the ValueList... To elaborate on the problem: Each meeting is attended by Members and Visitors. So, I am trying to keep track of each. Link to comment Share on other sites More sharing options...
bruceR Posted March 26, 2011 Share Posted March 26, 2011 A few fixes. MembershipXX.fp7.zip Link to comment Share on other sites More sharing options...
ron G Posted March 26, 2011 Author Share Posted March 26, 2011 Got it! This is embarassing... The problem was that the Visitors::Name_LastFirst was a calculated field set to return 'Number" instead of "text".... ba boom. I don't think I will forget this one! Thanks to all who conributed. Your comments and questions really helped. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4778 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