[AccessD] Data Input - Normalized Database

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Thu Apr 22 10:56:33 CDT 2004


Susan,

OK, I created the query... with all the fields.  Next, I tried to do a
simple autoform to see if it would work...NO controls showed up on the
form:(  In design view the controls exist, but in form view they do not.
I'm open for suggestions as to why...



Mark


-----Original Message-----
From: Susan Harkins [mailto:ssharkins at bellsouth.net] 
Sent: Thursday, April 22, 2004 10:38 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Data Input - Normalized Database


You add them to the query, even though you don't need them in the form --
and 11 tables can still be updateable -- depends on the relationships
between the tables. 

Susan H. 

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?

-- 
_______________________________________________
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