When creating a primary/foreign key relationship there are the following options:
- Check Existing Data On Creation [Yes/No]
- Enforce for Replication [Yes/No]
- Enforce Foreign Key Constraint [Yes/No]
What are the uses for all these when you select 'Yes' or 'No' ?
Because when deleting the record with the primary key, I have a problem if there are any foreign key relationships, it doesn't let me delete. So how do you delete all related records to primary key at that same time? or how do you ignore other foreign records when primary is deleted and allow the delete?
I searched online but can't find the answer to my questions.