[AccessD] Entering data in related tables in a single form

John:

Can you force the user to create the parent record (at least as far as 
the insert event so you have a PK) by making the sub-forms bound to the 
child tables disabled until the parent record is created and you have 
the PK in hand?

Is it one primary parent table with several one-to-many child tables?

Rocky


John Colby wrote:
> I need a quick and dirty form to enter data into a whole set of related data
> tables.  Policy holder, policy, claim, claimant etc.  
>
> Is this possible?  Obviously I have relational integrity turned on so the
> PKs have to exist in the "parent" tables before they can be used to enter
> data into the child tables.  I seem to remember trying this ages ago with
> less than stellar results.  Has anyone here done something like this, and if
> so how?
>
> John W. Colby
> www.ColbyConsulting.com 
>
>
>   

-- 
Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com