[AccessD] Data Input - Normalized Database

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Thu Apr 22 08:52:21 CDT 2004


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
>




More information about the AccessD mailing list