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

<<<
> seem to remember trying this ages ago with
> less than stellar results.
>>>
John,

What issues do you mean? (It should work well in MS Access with properly 
organized forms (with subforms) and maybe with a few lines of code)...

I suppose your base is in "bounders camp" while looking  for this "quick and 
dirty form" solution :)

Shamil

----- Original Message ----- 
From: "John Colby" <jwcolby at ColbyConsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, February 28, 2006 9:02 PM
Subject: [AccessD] Entering data in related tables in a single form


>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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com