Query when ran is not deleting records in table

rdev

Registered User.
Local time
Tomorrow, 02:48
Joined
Mar 2, 2009
Messages
18
I have a table called tblapprovedquote with fields App_Num and Quotation_num
I have another table tblquotation with fields Quotation_num and Voy_Num
Both tables are related in a in a one-to-one relationship . I have a query which pulls fields App_Num , Quotation_num from the tblapprovedquote and Voy_num from tblquotation , The query works
But when I delete the records in the query , it is not deleting records in the tblapprovedquote .
What could be the reason
 
Do you have cascade deletes turned on in the relationships?
 

Users who are viewing this thread

Back
Top Bottom