I have a subform with a lookup field back to the ID of the main form.

If I delete the main form, shouldn't it delete the subform records?  Or do I have to script this somehow?  Right now, when I delete the main form, the subform's lookup field is cleared, but the record remains.

Thanks for any assistance...