>>Is it possible to have 2 related tables in a grid control? One table has a field containing agency codes, and another table contains the descriptor data (e.g., agency name) keyed by agency code. I tried to include fields from the 2 tables while in Grid Builder, however, it appears as if only one table can populate the Grid. Any ideas ... or do I need to go back to the good ole' Browse command?
>>
>>
>> Thanks,
>>
>> Glenn
>Glenn,
>
>The limitation you are seeing ias ht grid builder NOT the grid. Build your gird with the grid builder, then in the data environment for the fomr put your two tables and set the relationship between them. Now go to the grid and change its columncount to increase it by one. Drg the new column to the position you wnat it in and set the columns controlsource property to Alias.FieldName for the field you want rfrom the related table.

This will work fine with one more add-in: sometimes grid 'refreshment' routine should include resetting of the relationship to properly reflect possible value changes in second table.