woodyards
09-21-2000, 06:55 AM
I am trying to delete a record from a table that is the one side of a one-to-many relationship. Nothing happens.
The SQL is :
tempSQL = "Delete * FROM Employee " & _
" WHERE EmployeeID = " & tmpEmployeeID & ";"
DBTemp.Execute tempSQL
Do I need to delete the many side of the relationship first?
whelanp
09-21-2000, 07:03 AM
What data type in your employee ID.
woodyards
09-21-2000, 07:17 AM
Number, Integer; If I had the wrong datatype, wouldn't I get an invalid datatype message? Thank you for replying so quickly to my post!!!
Valkyrie
09-21-2000, 01:35 PM
If you have set "Enforce Referential Integrity" on but not "Cascade Deletes" on the relationship between the two tables then you cannot delete the 1 side if entries exist on the many side. Either delete all the matching entries from the many side first or, set the "Cascade Deletes" on so that deleting from the 1 side will delete all the related rows in the many table.
HTH./images/icons/tongue.gif
Quote of the moment....
"My job is so top secret even I don't know what I'm doing!"
bmclauchlan
09-27-2000, 07:51 AM
Are you getting error message(s)??? And if so what are they?
Brent