Broken Relationship?

[scolesm]

Hey there,

I'm running FileMaker Pro 8.0v1. I've got a database of products that I've been maintaining for some time now. Each product is linked from an Item Master (IM) layout to ingredients, qualities, display layouts, etc. by a primary key.

Lately, with one item, the IM data has stopped appearing. When I search the IM layout for the primary key (or any other piece of data related to this item), the fields displayed on one record appear empty and cannot be edited. I can't even see data in the field that I searched to find the record. Looking at a field linked to this record from any other layout, it appears empty and cannot be edited.

I've created a new record for this item and deleted what I could, but the IM record which seems to contain no information cannot be deleted. When I search for it and delete it, the found count goes to 0, but the total remains the same and the record remains.

I'm sure I'm not the first to encounter this, but I cannot find a similar post. Can anybody help me either understand the problem or just get rid of the remaining record?

Thank you very much,

Michael

[AudioFreak]

Is this file hosted or stored on a local machine? How do you connect to it?

You probably don't want to hear this but it sounds exactly like corruption. Has this file crashed on you before? By crashed I mean closed unexpectedly.

Michael

Edited January 10, 2008 by Guest

[scolesm]

It is hosted, we have a different staff member that deals with the Server-side of things (I wish they'd let me). The file has closed unexpectedly a few times. Usually, this is involved in the printing.

This doesn't make me happy at all, but thanks for the help.

What steps can I take to clean things up?

[AudioFreak]

Well you can shut the file down on the server and open it locally. Go to file>Save a copy as "Compacted". Then rehost the file and see if the problem is gone. Sometimes this will remove corruption.

Your best bet is to go back to a known good backup.

Michael