>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.
Thats exactly what is NOT working. I have proper indexes (PK in one table FK in the other just as it is supposd to be) but I can drag but it does not allow me to drop and also menu pads 'Edit Releationship' and 'Edit Referential Integrity' are greyed out.
I do remember years ago seeing something about this but I cannot remmber what :-)
what is missing here???????????????????????
>
>>>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
Peter Cortiel