Do you have the project open on a data tab? Be sure your project is closed and the database is closed BEFORE you open it again exclusively.


>i have the dbc ope exclusivly, did clean up database, did validate datbase recover cleaned up again and still no potatoes...
>
>
>>You must have the database open exclusively and you need to have a freshly cleaned up the database before the RI builder will run. I thought it would still be avaiable on the menu (not greyed out) but would pop up a message box indicating what was wrong though.
>>
>>>I did a validate data recover and still no ref integrity
>>>
>>>
>>>>Both of tables must have indexes. One of them tables must have a Primary index. Get the index name from table window and drag it to second table index name thus You build a relation. Duoble Click on Relation & You get "Edit relationship" window. On it there is a Referencial Integrity Button.
>>>>
>>>>>>Put some tables in DBC,
>>>>>
>>>>>Just did
>>>>>
>>>>> Create relations between them
>>>>>
>>>>>Thats what does not work!!!!!!!!!!!!!
>>>>>
>>>>>& make sure if You are opened the DBC exclusive
>>>>>
>>>>>It is
>>>>>
>>>>>
>>>>>PS I can clean up the database since it is open exclusively
>>>>>PS vfp8sp1, xpsp2
>>>>>
>>>>>
>>>>>>
>>>>>>>I am creating a new dbc (first time in years!, and once over 60 one forgets everything)
>>>>>>>the referential integrity builder is greyed out. I don't remember what to do to be able to create ref. Integrity
>>>>>>>
>>>>>>>Thanks
>>>>>>>
>>>>>>>Peter