Hi Larry,

I am running VFP 8.0. I also thought that my DBC was corrupted but I used the VALDIATE DATABASE RECOVER commands quite a number of times. Each run, VFP claimed that everything was OK. I got the database cleaned also on several occasions.

Pat



>Pat,
>Have you tried refreshing and cleaning up the DBC from the menu? Sounds like your dbc may be corrupted. What version of VFP are you running?
>
>>Hello Larry,
>>
>>No, no ... everything is done through the visual view of the database, simply bry dragging and dropping the index tags on each other.
>>
>>Pat
>>>Pat,
>>>Are you setting your relationships programatically? If so, make sure that you use the ADDITIVE clause if multipe relationships need to be set, other wise the SET RELATION will drop any current relationship.
>>>
>>>HTH
>>>
>>>>Hi All,
>>>>
>>>>I have a strange problem at hand here. It seems that some of the relations involved in a DBC get lost when I modify some tables.
>>>>
>>>>This is a 50 tables DBC, in which there are many relations between the tables. For example I have a PROJECTS table and a CUSTOMERS table. Both table are linked with a CUST_ID field (a project is linked to a customer).
>>>>
>>>>If I update say another table in the system (the MODULES table for example), I suddenly lose the relation that once linked the PROJECTS and CUSTOMERS table together.
>>>>
>>>>Is this a known problem and is there any way to prevent this from happening?
>>>>
>>>>Thank you.
>>>>
>>>>Pat