I am using FM 12 03 Adv in OSX and WIndows

 

I have this setup:

 

Members TOC:-        MemberMeetingJoin       Meetings            VisitorMeetingJoin       Visitors

KP_MemberID -----[ KF_Member                                                 KF_VisitorID ----------[PK_VisitorID

                                 KF_Meeting--------------[KP_MeetingID----[KF_MeetingID

 

Sorry I can't upload a capture of the TO's but the forum is generating this message when I try "No file selected for upload"???

 

I have a layout based on MEETINGS

I have 2 portals on the meetings layout:

 

#1 )  the left portal is based on MemberMeetingJoin   ... it works great.

#2)   the right portal is based on VisitorMeetingJoin... it kind of works.

 

ON #2 layout I have the field VisitorMeetingJoin::KF_VisitorID.  This field is a PopUp that is configured as:

Values from the 1st field:  Visitors::PK_VisitorID

Value from the 2nd Field:  Visitors:: Name_LastFirst

 

When I use the popup, everything seems great.  Everything appears to work.  I make a selection and the name is put in the field.

But, if I import a previous version of the same project, the popup shows the ID of the field instead of the name???  (Yes, the imported file shows the name)

 

I know this is a long winded, somewhat convoluted description of the problem and that without an ability to upload captures of the situation it is more complicated.  I hope someone who is more experienced than I am can understand what I don't get.

 

Thanks for reading.

 

 

 

Not clear what your problem is, sorry.

 

However, have you considered a People table? Then your join would contain a type field (Member or Visitor). You wouldn't need the VisitorMtgJoin or the Visitor table.

 

The PeopleMtg join could easily be filtered by type.

Got it to work.

The problem had nothing to do with the relationships. 

 

The problem was how I had set an import script step to "PERFORM AUTO UPDATE OPTIONS WHILE IMPORTING" one the Visitors table.  This seemed to screw up the Visitors Primary Key.  Once I turned that 'feature' off, ba boom... everything worked.

 

Hope this helps someone else with the same problem....