Can I enforce referential integrity using relationships?
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.