[AccessD] Data Input - Normalized Database

11 tables...maximum of 2 levels of dependencies.  But, forgive all these
newbie questions, if I use a query, how do I populate the foreign keys?



Mark


-----Original Message-----
From: Rocky Smolin - Beach Access Software [mailto:bchacc at san.rr.com] 
Sent: Thursday, April 22, 2004 9:52 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Data Input - Normalized Database


Mark:

Can  you base the form on a query which joins all of the tables?  Or would
it be too many tables.  IIRC there's some limit of the number of tables in a
query after which it's not updateable.

Rocky Smolin
Beach Access Software
http://www.e-z-mrp.com


----- Original Message ----- 
From: "Mitsules, Mark S. (Newport News)" <Mark.Mitsules at ngc.com>
To: "'[AccessD]'" <AccessD at databaseadvisors.com>
Sent: Thursday, April 22, 2004 6:15 AM
Subject: [AccessD] Data Input - Normalized Database


> We have a simple paper form that is used for data collection.  For
purposes
> of simplistic data entry, I would like to create an Access form that
mimics
> the actual paper form.  The underlying tables, however, are fully
normalized
> including dependencies.  The dependent fields are scattered throughout the
> existing paper form.  Can I create a single bound form (subforms are ok)
> under these circumstances?  If so, how?  The examples that I have run
across
> usually use multiple forms and pass the foreign keys.
>
> I can do this going unbound, but I'd rather not.
>
>
>
> Mark
> -- 
> _______________________________________________
> 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