A
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....
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....