[AccessD] Child records entered before parent

John W. Colby jwcolby at colbyconsulting.com
Fri Sep 9 12:02:03 CDT 2005


LOL. let's just wait for other responses eh?

John W. Colby
www.ColbyConsulting.com 

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

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, September 09, 2005 12:53 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Child records entered before parent


Um, John?  In bound forms, moving from the parent form to the subform saves
the parent record.  If there's no parent ID, it sounds like you have a
bigger problem.  I generally disable the child subform until the parent form
is complete.  Of course, you could also enforce referential integrity
between the two tables, which wouldn't allow you to save the child record
anyhow without a parent.  I know you know about all that, so are you doing
something exotic that you didn't explain?

Charlotte Foust


-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Friday, September 09, 2005 9:22 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Child records entered before parent


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/


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com






More information about the AccessD mailing list