delete record from subform

[Ann]

Sorry if there is an answer out there already I
cannot 'search' in a reasonable amount of time (takes at
least a full 3 minutes to move to next page).

Form and subform sends data to same table, subform was
created because many records will have the same data over
and over and I wanted to spare the data entry people. The
problem is that when I delete a record from the subform
the fields on the main form are not deleted leaving the
data in the table. I know how to enforce referential
integrity between two tables but I don't know how to do it
when there is only one table, or even if it can be done.
any insight is greatly appreciated as always....

 

[Ann]

Thanks for the suggestion to use google....and of course I
am an idiot I was thinking that the child/master link
would allow me to 'link' the data on the forms....have
since separated the data via another table and enforced
referential integrity like I knew it should be, thanks for
the insight....

-----Original Message-----