Deleting an orphan record

[Guest]

Hello,
I have a database with a corrupt record. This record was a foriegn key to
another table. The user who discovered the error (garbage was entered into
the fields) went to the table and deleted the record, not realizing that
there was another table dependant on that record. When I try to delete the
now orphaned record in table 2, I receive an error - The search key was not
found in any record. Clicking help identified this as error code 3709. I've
tried going into the Relationship tool and deleting the relationship to
delete this record but that doesn't do it. Any ideas on how to delete this
sort of orphan?
Thanks, Lisa.

 

[Guest]

Hi, Lisa.

Have you tried adding a parent record, setting the relationship to Cascade
Delete, and deleting the parent record (which will delete any children)?

Sprinks

 

[Guest]

hi Sprinks,

Unfortunately, it's the parent that has already been deleted. I'm not sure
what index it is referring to in the error as I tried to recreate the key
record with the same number that is the primary-foreign key, but it still
gave the same error when i tried to delete the orphan. It seems to be stuck.

Lisa

 

[Guest]

Hmm. Did you try Compact and Repair?

hi Sprinks,

Unfortunately, it's the parent that has already been deleted. I'm not sure
what index it is referring to in the error as I tried to recreate the key
record with the same number that is the primary-foreign key, but it still
gave the same error when i tried to delete the orphan. It seems to be stuck.

Lisa