[AccessD] Preventing childless parent records

Mcgillivray, Don [IT] Donald.A.McGillivray at sprint.com
Mon Mar 6 16:42:16 CST 2006


Hello, All

I have a data entry form for entering transactions where the main form
holds the transaction header and a subform holds the header's details.
Works as advertised, except that I have a user who has a habit of
creating headers without adding line items.  She sets up the header,
tabs into the line item section, gets distracted (I guess), returns to
the form (after dealing with the distraction) and starts over for some
reason.  Now, by virtue of having tabbed into the line item section, the
header was saved, but because no line items were ever entered, the
header is an orphan, or, more accurately, a childless parent.  Every
week, I scan the data and find several of these records that need to be
removed.  

My first approach was to educate the user about how to do data entry.  
My second approach was to educate the user about how NOT to do data
entry.

Both approaches netted me that vacant nodding smile that says "I don't
know what you're talking about, but if I keep nodding like this, maybe
you'll go away and leave me alone."  I'm sure you're all familiar with
that look.

This must be a common problem - the childless parent record, not the
vacant nodding smile - but I'm struggling with how to detect the
condition and disallow it.  Can anybody point me in the right direction?

Thanks!

Don




More information about the AccessD mailing list