Post reply

How to delete subform data along with main form

  • August 11, 2005 at 4:38 pm

    #165707

    I have 3 sub-forms inside the main form with the subforms ID linked to the Main form ID.  I can't figure how to delete all the information in all the forms.  I only get the to delete the main forms data. The forms are made in Access 2000 with sql as the back in.  I tried in visual basic but can't figure it out.

  • August 11, 2005 at 5:13 pm

    #581629

    You can either use a stored proc to do the delete from the main form (and manually delete from all 4 tables). Or you can use on delete cascade option so that the 3 child tables don't get orphaned data. This is assuming that you have created relations between the tables.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply