Albert, As soon as I read your statement I knew the answer. Did a RELOAD and things work great. Duh on my part. Thank you very much. Still, I will wander off to look at why the indexes might have broken. Think I will be doing weekly reloads just for insurance.
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 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Albert Berry Sent: Monday, January 28, 2008 12:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Primary Key question It sounds like broken indexes to me. Tom Frederick wrote: > > 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] <mailto:[EMAIL PROTECTED]> > > Web - www.elmcity.org <http://www.elmcity.org> >
