Relationship and/or ValueList problem

[ron G]

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.

[comment]

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'.

[ron G]

OK. Here is the Membership.fm7 file.... Thanks for your help.

MembershipXX.fp7.zip

[bruceR]

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?

[ron G]

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.

[bruceR]

A few fixes.

MembershipXX.fp7.zip

[ron G]

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.