Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Thu Apr 22 11:38:26 CDT 2004
Nope it's not updateable... Anyone want to look at a screenshot of the relationships to see if they could tell why? I guess what I'm asking is, what is the limiting factor of a recordset being updatable or not? I'm guessing that it has to do with the 2 levels of dependency. Could that be it? Mark -----Original Message----- From: Susan Harkins [mailto:ssharkins at bellsouth.net] Sent: Thursday, April 22, 2004 12:22 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Data Input - Normalized Database 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com