>>>My questions:
>>>
>>>how do I just show the specific company's contacts in the grid, not all in the table/view?
>>>
>>>how do I link the grid and the company text box so when I change the company Name, the grid refreshes to show the "new" company's contacts?
>>>
>>>and one last "wish"... I'd love for the user to be able to click the grid headers to reorder the grid, i.e. click the "Position" header to order by position and "Name" header to reorder by employee name. I've seen how to do this with tables and indexes, but not how to do this with views.
>>>
>>>Many TIA,
>>>Mandy
>>
>>it really sounds like the company should be the parent for this setup. what happens when you try to set that relation? once this relation is set, showing only the current company's contacts is easy. set the parent and relationalexpr properties for the grid to the appropriate values.
>
>My thoughts exactly ;)! But it seems the only way to build relations in the Data Environment is by dragging the Parent's field to the Child's index. Since my Child in that case would be my Contacts View and I can't figure out how you can build an index on a view, I can't get it to work. And I have tried right clicking the relation line to edit the properties, but the Child/Parent Alias boxes are grayed out so I can't access them to change them. Ideas???

define the index and set the relation in the init of the form. i think you'll need to refresh the grid (already set up by time form.init is run), but should give you everything you need.

>
>>
>>you can index views on the fly
>>
>> select myview
>> index on field1 tag field1
>> index on field2 tag field2 additive
>>
>>then use this just like a table and index...
>
>Great thanks!
>
>Mandy