Is it possible to delete from two tables with one SQL run?

  • Thread starter Thread starter Reney
  • Start date Start date
R

Reney

I have an Employee Table with "employeeID" primary key. And this table has a
"one to many " relation with TimeLog table, which has "employeeID" and
"dayOfWeek" as Primary Key fields.
In one form, I need to delete an employee selected by the user of the
program. But since Employee table is related to the TimeLog table, it won't
let me to delete. How could I delete the selected employee from both of the
tables?

Reney
 
Hi Fergus,

Thanks a lot for your response. I corrected my problem following your
reccomendation. After I deleted all the TimeLog entries, there were no
problems left to delete the record in the Employee table...

Have a great day,
Reney
 
Back
Top