hello,

got two tables that are linked buy a customer id. i need to delete the
customer's details from the CUSTOMERS table and the customers info from the
ENTINFO table.

at the moment i've got this in my sql:

"DELETE FROM CUSTOMERS WHERE WINNERID IN (" & strDeleteList & ")"

where strDeleteList is defined on the previous page with check box's.
because the check box's no will be the same in both tables i figure put them
in the same statement!

but how!!!

any feedback would be grand,

cheers,

jake

DELECT FROM
    ChildTable
WHERE
    ForeignKey IN (" & ... & )

DELETE FROM
    ParentTable
WHERE
    PrimaryKey IN (" & ... & ")

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "jake williamson 28" <jake.williamson@2...>
Subject: [access_asp] deleteing from two tables with the same record id


: got two tables that are linked buy a customer id. i need to delete the
: customer's details from the CUSTOMERS table and the customers info from
the
: ENTINFO table.
:
: at the moment i've got this in my sql:
:
: "DELETE FROM CUSTOMERS WHERE WINNERID IN (" & strDeleteList & ")"
:
: where strDeleteList is defined on the previous page with check box's.
: because the check box's no will be the same in both tables i figure put
them
: in the same statement!

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~