Want to delete 1 id record from all tables

wordstring = "DELETE * FROM patient WHERE patient_id = "&pid&" "
con.execute wordstring
wordstring = "DELETE * FROM patientchart WHERE patient_id = "&pid&" "
con.execute wordstring

I used this way, Is there other way to identify all table coz it can't use * to identify all tables

Thank you

If the patient table and the patientchart table have a relationship between each other based on patient_id and the relationship is setup to allow cascade Deletes, then all you have to do is delete the record in the parent table (patient) and it will automatically be deleted out of the Child table (patientchart).

It sounds like this relationship doesn't exist, so the answer would be No.

If you will be doing this alot, then create the relationship, however I usually recommend NOT allowing cascade delete and to delete the records form the table individually (like you are doing) I say this because I usually have relationship set up and enforce intergrity and 9 times out of 10 deleting the parent records usually deletes child records that is needed for historical information, down the road, and I don't want to make it easy to delete that information.

S-