Mitsules, Mark S. (Newport News)
Mark.Mitsules at ngc.com
Thu Apr 22 12:39:01 CDT 2004
The light came on! I started from scratch, building the query again, table by table. After each addition I checked the "updateable-ness";) The problem was caused by a single table that I SHOULD have added three times, but hadn't. It was a personnel table whose PK was used as a FK 3 times in another table. Access had automatically added the defined relationships. I needed to delete 2 of the 3 and add the table again to the query 2 more times. As soon as I fixed that oversight, the query worked. Now I just need to get a working form from all that. Thanks, Mark -----Original Message----- From: Pickering, Stephen [mailto:Stephen.Pickering at caremark.com] Sent: Thursday, April 22, 2004 1:22 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Data Input - Normalized Database Mark, Check to make sure that all of the Primary Keys for all of the tables are included in the SELECT clause. Steve -----Mark S. Mitsules' Original Message----- 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com