AnsweredAssumed Answered

Keeping Many to Many Relationship Integrity

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

Title

Keeping Many to Many Relationship Integrity

Post

All,

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!

Outcomes