many to many to many...

[ron G]

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.

 

 

 

[bcooney]

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.

[ron G]

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