Well I guess this is one of those mysteries..... :-(
Thanks anyway!

Peter


>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