Howdy!
vb.net (forms) app using INSERT statement into table, tha contains an ID column that's
an Identity column.
I have another table related by said column(it's the foreign key, and NON Identity)
In SSMS,, the relationship states that Delete & Update Rule(s) = Cascade
When I run the INSERT statement, I get nothing in table#2
no errors, just no new row
I'm not a guru, so maybe I'm expecting something that's not meant to be by issuing one INSERT statement and expecting
two tables to receive the row
Thanks lads,
Rich
vb.net (forms) app using INSERT statement into table, tha contains an ID column that's
an Identity column.
I have another table related by said column(it's the foreign key, and NON Identity)
In SSMS,, the relationship states that Delete & Update Rule(s) = Cascade
When I run the INSERT statement, I get nothing in table#2
no errors, just no new row
I'm not a guru, so maybe I'm expecting something that's not meant to be by issuing one INSERT statement and expecting
two tables to receive the row
Thanks lads,
Rich