>>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,
>
>There are three places in VFP where tables cna be related to each other.
>
>1) in the database container - these are called persistent relations - they are created by draggin a primary index to a primary or reguar index of another table.
>
>2) in the data environment of a form or formset - these are created by dragging a field to the index of another table.
>
>3) in the view designer - these are created by dragging a field to a field in another table.
>
>Perhaps that is where your confusion is comming form, you were trying to do things in the DE of a form the way they are done in the database container.

Jim:

Whoa! I knew of the 2 but not the third. Thanks for clearing that up for me. I think I can manage it from here.

Ernie