AnsweredAssumed Answered

Can I enforce referential integrity using relationships?

Question asked by billcritten on Mar 9, 2011
Latest reply on Mar 9, 2011 by billcritten

Title

Can I enforce referential integrity using relationships?

Post

I created a Master/Detail table setup and joined the tables on the ID fields where ID is primary key in Master and Foreign key in Detail.  I also checked the box to allow to create records based on this relationship in the detail table.  The idea is that the user should not be able to save a detail data record unless there is a corresponding record in the master table.  Is it possible to enforce this?  How to achieve this?  No worries about any complexities (as I am a coder).  I just need to learn the ways of FM.

Thanks

Outcomes