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