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!