Delete query error could not delete from specified tables

[sivani_007]

i keerp getting an error "could not delete from specified tables"



I have a table with this data

Main table
bub|12345|1
bub|45678|2
bub|91011|3

Child Table
bub|45678|2

result in Main table

bub|12345|1
bub|91011|3

match from child table and delete from main table..
but i keep getting error "Could not delete from specified table
main table has unique records. and it is primary key..
please help

 

[JHB]

Have you set up the right relationship, like "Enforce Referential Integrity", "Cascade Update Related Fields" and "Cascade Delete Related Records"?

 

[sivani_007]

that's great It works now. thank you so much for your help

 

[JHB]

You're welcome, good luck.