Do you have a primary key index on each table and foreign key indexes in related child tables with a permanent relation set from parent to child?

>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