[AccessD] Child records entered before parent

John W. Colby jwcolby at colbyconsulting.com
Fri Sep 9 11:22:07 CDT 2005


Regardless of the PK type of choice, allowing the user to enter child
records before the parent is valid can create a mess in your database.
Using bound forms, a subform will happily allow the user to enter a child
record when the parent form is on the new record.  What happens then is that
the child record is saved  but there is no valid parent ID so the entered
record is immediately "orphaned".

So how do you guys handle preventing the user from entering data in child
forms if the parent form is on the new record?

John W. Colby
www.ColbyConsulting.com 

Contribute your unused CPU cycles to a good cause:
http://folding.stanford.edu/





More information about the AccessD mailing list