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.

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

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

MembershipXX.fp7.zip

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?

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.

A few fixes.

MembershipXX.fp7.zip

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.