>>>>How does one set a relationship in the data environment of a form? I know it can be done, but I'm curious if it's possible without a DBC. I have a client who needs to use the files in DOS mode as well as VFP 3.0, so I can't use a DBC. MS suggests, for the sake of performance, to use the Data Environment for relationships. Has anyone out there set a relationship at the form level w/out a DBC?
>>>
>>>You don't need to have a DBC. Just fill in the blank properties.
>>>
>>>You can also do it at the grid level if that applies.
>>
>>Which blank properties? I assume you're talking about the data environment, but is it a property on the environment or on the table within the environment? I've seen Order, but not Relation.
>>
>>Thank you,
>>JR
>
>relation isn't part of a table/cursor. it's a tie between two tables/cursors. you'll need to add these yourself by dragging desired field to matching field in another table. this will set the relation.

Yikes! Thanks. . . I was attempting to drag the index tag, not the field. I noticed that you can drop the field on EITHER the tag OR the field. I assume dropping it onto the tag will mean better performance. Also, I've set the order in the child files. Is it necessary? Will it mean better performance?

Thanks alot!

JR