Can 1 query delete data from 2 tables ?

[bugsy]

DELETE FROM tblUnivPort, tblUnivFunc
WHERE tblUnivPort.Univ= tblUnivFunc.Univ 
AND tblUnivFunc.Proc="PORTCHAR";

 

[bugsy]

a little more details --

both table s have composite primary keys

tblUnivePort - Univ and Port
tblUnivFunc - Univ, Proc, Func

I can't seem to make "CASCADE DELETE RELATED RECORDS" with this...

 

[khawar]

You can run two sql delete statements in vba instead of using query