[AccessD] Data Input - Normalized Database

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