[AccessD] Data Input - Normalized Database

Mark:

I think the FKs need to be inserted through code.  At least that's how I
always did it.

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: "'Access Developers discussion and problem solving'"
<accessd at databaseadvisors.com>
Sent: Thursday, April 22, 2004 7:13 AM
Subject: RE: [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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>