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>
--- RBASE-L
=======================3D=======================3
D=
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
=======================3D=======================3
D=
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
=======================3D=======================3
D=
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
=======================3D=======================3
D=
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
=======================3D=======================3
D=
