You must be alowed to drop an index over onother (not on the field) I have no idea what happens :o((((((((



>>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