Susan Harkins
ssharkins at bellsouth.net
Thu Apr 22 11:21:52 CDT 2004
Check out the query's datasheet -- is there a new row? If not, it isn't an updateable setup. Susan H. 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com