>Can someone confirm whether this is a VFP 3.0 -vs- 5.0 version difference. In Whil Hentzen's book on version 3.0 , pg. 295 states "Drag index names (not field names)from one table to another." I tried unsuccessfully for hours. But I'm using VFP 5.0 so I checked the RelationalExpr property of a relationship in my data environment and it states the property, "Specifies the expression based on fields in the parent table that relates to an index in the child table." Note: field names NOT index names. Hmmm ... So I try it and it works!
>
>Is this a subtle difference between versions 3 and 5? Can anyone recommend a good laundry list of "Differences between 3.0 and 5.0"? I've been told they're not major differences but like FILER disappearing and maybe this RelationalExpr property, I'd just assume save myself the hair pulling. Thx.

Ernie, are you in the DATABASE DESIGNER or in a form's Date Environment? If the former, then Whil is correct for both VFP5 and VFP3.

If you're in a Form's DE, then my short answer is DON'T set relations here, and the longer one is that in the DE you can drag from parent field to matching child field and the relationship line will go from parent field to child index.

However, if you DO want relationships in a form, set them in code, please. It will keep you from running into problems with grids, multiple children, etc.

HTH
Barbara