To cascade deleted fields, you have to go into the
database's Relationships section. You have to have a link
between the forms. One of the forms MUST contain a unique
index (Primary Key if you want, just so long as it is
unique, you don't have to make the field a primary key)
that is part of the link. When you are creating the link,
you need to check the "Enforce Referential Integrity" box,
then select the "Cascade Deleted"...you might also want
to "Cascade Updated" information.
Good Luck!
-----Original Message-----
I want to add a command button that deletes the current
record although there are associated records from another
table. I know I need to cascade the delete but the help
menus are vague. Could someone please help?
