AnsweredAssumed Answered

Keeping Many to Many Relationship Integrity

Question asked by PhilipTolbert on Sep 11, 2011
Latest reply on Sep 12, 2011 by philmodjunk


Keeping Many to Many Relationship Integrity



I am using FM Pro 6 (still) and ran into an issue with a new database design.

I have the following files and Designs:

File A; with primary key A

File B; with primary key B

File AB; with foreign keys A and B

I have built all of the necessary relationships.

In File A I have a form with a Portal view of the relationship between A and AB.

If I enter data all is good unless I go to File B and change data.  The data doesn't seem to update in File AB.


Any ideas?  THank you in advance!