before append test for existance.

D

dhurwyn

We run Multiple series of letters in a defined timeline. We run an
append query to set up the Letter tracking table on the first letter
and thereafter an update query to track the letters.

What we have noticed is that when users are on the informational form
if they click on the Letter tracking tab, the subform based on the
letter tracking table automatically creates a record in the table for
this entry. When we run the first letter we wind up with multiple
records for the letter tracking.

Best Practice advice.

Is it better to set up this record when Data Entry is adding the
information in the main table; (Not all records get letters based on
numerous criteria.so may create bloat) or
Block the addition of a new record in the letter tracking table when in
the information form; or
use a test to see if the record exists when running the letters for the
first time and mix the Append with an update query.

Thank you for your assistance.
Demi
 
Top