I have several table systems that use a PK as a driver for related tables. Example: Customers has an ID that is autonumbered and PK. This ID is used in 12 other tables which are FKed back to this main table's PK. Works great and worked great up to Saturday when I last used it. This morning it stops working for tables and forms that I have not changed. EDIT USING and ENTER USING start the FK based forms as always, but SAVE gives a message that the ID number cannot be found back in the PK table even though the ID is in both tables. I know where the message comes from. When I turn the FK off, everything works fine. The other two systems that use the exact same process of PK/FK work like they always have. The puzzler to me is why one system has a problem and the other duplicate systems just chug along. Went back on a backup DB copy from 3 days ago and everything works like it always has so I figured I did something, but nothing is different that I can see except turning off FK. I am going back through the documents about PK/FK to see what I might have changed, but so far I am not seeing anything that jumps out. Is there some other place to look?
Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
