Relationship screwed up.. but how?
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?