Loosing relationship configurations when splitting a DB

[myhnews]

I have a one to many to many relationship; with the "Cascade update related fields", and "Cascade update related records" on the relationship properties checked.

Since I have split the DB to FE and BE, the relationship properties (for the 3 tables on the FE) is grayed out and cannot be changed.
In addition, the "Cascade update related fields", and "Cascade update related records" on the relationship properties is unchecked.

(The relationship properties on the BE is still configured to Cascade update.

Any solution?

Thank you
Joe

 

[ssteinke]

Does this thread help?

 

[myhnews]

Yes, it proofed me that I did the correct steps. I have manually split the DB.
Let me explain my problem,

I’m not trying to change any settings on the FE. But I’m wondering why the “Cascade update related fields", and "Cascade update related records" became unchecked on the FE?

I dragged the third table into the sub form of the second table. Now it does not update automatically the second tables' primary key.
In addition, I’m not even getting the + sign to add a record to the third table.
Thanks

Joe