1. i have 3 table.and every table have to relation.
2.i do QRY for 3 table link in from
3.i make from form for add, edit , and delete
my Qustion
1.when i delete in from but table not delete?
** i'm enforce and cascade delete related but can't delete it
in step 1 can't delete it i will do step 2
2.i make new button in code VBA
Private Sub Command123_Click()
DoCmd.RunSQL "Delete * from tbl_com"
Me.Requery
End Sub
it delete all record in table
i want delete 1 record in from and intable
help me pls..
2.i do QRY for 3 table link in from
3.i make from form for add, edit , and delete
my Qustion
1.when i delete in from but table not delete?
** i'm enforce and cascade delete related but can't delete it
in step 1 can't delete it i will do step 2
2.i make new button in code VBA
Private Sub Command123_Click()
DoCmd.RunSQL "Delete * from tbl_com"
Me.Requery
End Sub
it delete all record in table
i want delete 1 record in from and intable
help me pls..