I have many primary keys that are auto numbers and I have referential intergrity enabled. I want to know why when I create a new record that my auto number in the primary field does not automatically copy to the foreign key field? Do I need to manually create something that will make these fields identical? I thought by using referential integrity and using relationships between the fields that they would automatically do this. Any ideas what I am doing wrong?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
making records relate
- Thread starter dbh139
- Start date
Dugantrain
Active Member
- Joined
- Feb 10, 2003
- Messages
- 354
Are you entering records on linked parent/child forms? If so, have a look in the subform's properties and see what, if anything, the link child/link master properties are set to. If there is no setting, then that's your problem (The form design wizard usually links for you, but I seem to remember seeing a case where this wasn't true). If it's not a forms issue, specify how you're going about entering data and we'll see if we can help.
Upvote
0
Corticus
Well-known Member
- Joined
- Apr 30, 2002
- Messages
- 1,579
Hi dbh139,
You need to check 'cascade update related fields' when you set referential integrity.
You can check 'cascade delete related fields' if you want to delete related fields, but be VERY careful with this option, as you might inadvertantly clear out an entire table.
I prefer to use a delete query to delete related records, but I do cascade update related fields.
HTH,
You need to check 'cascade update related fields' when you set referential integrity.
You can check 'cascade delete related fields' if you want to delete related fields, but be VERY careful with this option, as you might inadvertantly clear out an entire table.
I prefer to use a delete query to delete related records, but I do cascade update related fields.
HTH,
Upvote
0
Similar threads
