delete record

J

Josh

Hi all:
fe: Access 2002, be: SQL server 2k
This is going to be very basic. I have a form with two
tables. A parent form has an inner join to a child table.
Because of referential integrity, if the user tries to
delete a record, the delete is not successful because the
child table record is not deleted. I have understood that
cascade deletes are dangerous.
How do I delete both records?
Thanks,
Josh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query vs form with child & parent: Deleting rows 3
Could not update, currently locked by another session on this mach 3
Continuous Forms - Insert New Record 4
Delete records from form and tables (Third Post) 7
How do I prohibit creation of new records in subform? 3
Form with subform and record insert problems 2
can't delete record 4
docmd.accmddeleterecord not working 2

Top