Hi all,
I am using an identity for a primary key. I have a foreign key in another table which references this primary key and for which the on update cascade is enabled. Does this mean that when i enter in a row for the table with the primary key, the table with the foreign key should also have the same value as the primary key?
For some reason, this is not working, and i don't know how to get around it. I won't know what the primary key value is, as i'm using the identity, so i need the database the automatically enter in the corresponding value for the foreign key, each time i insert rows into all the tables.
Thanks,
nisha
I am using an identity for a primary key. I have a foreign key in another table which references this primary key and for which the on update cascade is enabled. Does this mean that when i enter in a row for the table with the primary key, the table with the foreign key should also have the same value as the primary key?
For some reason, this is not working, and i don't know how to get around it. I won't know what the primary key value is, as i'm using the identity, so i need the database the automatically enter in the corresponding value for the foreign key, each time i insert rows into all the tables.
Thanks,
nisha