deleting from multiple tables

[rameshjctr]

friends



i am having 3 tables USERS,PERSONAL,SAL having common PEN as id. now i want to delete a record from these tables using a DELETE command button. i have coded on the clicked event
dim str as string
dim user as long
user = Text1(where i have to enter the PEN to delete)
str = "delete A.* , B.* , C.* FROM USERS AS A , PERSONAL AS B , SAL AS C WHERE A.PEN = B.PEN AND B.PEN = C.PEN AND A.PEN = user;"
docmd.runsql str

when i run it it shows a syntax error "Runtime error:3086. Could not delete from specified tables".

table users having fields PEN, ENAME
table personal having fields PEN, ENAME,ADDR
table sal having fields PEN,BASIC,DA,HRA

I want to delete ALL RECORDS FROM THESE TABLES DEPENDING UPON A PARTICULAR PEN VALUE

THANKING YOU

RAMESH

[ranman256]

You need 3 queries, not 1.
delete from each table individually.

[rameshjctr]

so i have to code 3 delete queries individually. ok friend thank you.

Ramesh J

[orange]

How are the tables related?
Please show your relationships window as a jpg.

Depending on relationships, and enforced referential integrity, if you delete a parent table, then children would be deleted.
But it depends on your table structure.
Good luck.