Jump to content

Relationship and/or ValueList problem


ron G
 Share

This topic is 4336 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am using FM 11ADV

I have been wrestling with this perplexing problem.

(Please see relationship diagram below)

ishot-609.jpg

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?

ishot-612.jpg

Is my FM datbase corrupted? Or, (more likely) "What am I missing???"

Thanks for reading.

Link to comment
Share on other sites

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?

graph_error.png

Link to comment
Share on other sites

Why would you relate visitors to meetings by visitor ID instead of meeting ID?

post-62898-0-45471800-1301114160_thumb.p

post-72145-0-35339900-1301115734_thumb.j

I 'think' this is what you meant? If so, it didn't work. Same problem. Just shows one Visitor in the ValueList...

post-72145-0-35339900-1301115734_thumb.j

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

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

This topic is 4336 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.