Value List works but does it really?

[ron G]

I am using FM 12 03 Advanced on OSX

 

I have a layout based MEETINGS and a portal on that layout based on MemberMeetingJoin.  (FYI The LO is based on Meetings because to the right is another Join Table that holds VISITORS and there is a second Layout to the right that holds a portal based on Visitors.)  Everything works OK

 

 

On the left Members portal, I have the the MemberMeetingJoin::KF_Member field.

 

 

The Value List definition for MemberMeetingJoin::KF_Member is:

 

 

And consists of the KF_Member field and NotDOP which is a calculated field that puts the name of the member in the NoDOP field if the member is not deceased.  It works

 

==========

 

This arrangement generates a report:

 

... which has this outcome:

 

 

What perplexes me is that the KF_Member has the member Name from the popup in it while the MemberName field is blank.  Am I corrupting my KF_member field with this arrangement? 

 

The report works well as long as I treat the KF_Member as the name.  But, "shouldn't KF_Member be getting KP_Member value and the Memberr Name field get the Member Name?

 

In retrospect I wish I had developed this app with a 'status' field that would be " Member, Candidate, Visitor".  It would have been a lot simpler.... But, too late to change now.

[ron G]

Solved.  (I think)

The crux of the problem was that the kf_ field showed values from a previous definition of a value list.  Although the value list was 'redefined', it still showed incorrect values.  When I deleted the field from the layout and brought the same field back into the layout everything looked as expected.  Weird.... But it worked... for some reason...