AnsweredAssumed Answered

Relationship screwed up.. but how?

Question asked by synergy46 on Feb 8, 2011
Latest reply on Feb 8, 2011 by philmodjunk

Title

Relationship screwed up.. but how?

Post

I am running FM 11 Advanced.

I have these 2 tables:

MEMBERS: KP_MemberID, LastName, .... , ZIP  (LEFTFIVE is a calculation field:  left(ZIP; 5)  )

ZIPCODES:  ZIP, City, ST

When I 'relate' Zipcodes::ZIP to Members::LeftFive I get  a many-to-many <<-->> relationship?  Huh?

(The real problem with this is that I think this 'weirdness' is preventing my city, state lookups from working)

I have an almost identical database with almost identical tables and when they are 'connected' they produce the expected

Members:LEFTFIVE <<----> ZIPCODES::ZIP relationship.

WZZZ going on?

ishot-460.jpg

Outcomes