>>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.


Jim,

Thanks a million for your advice! Your procedures worked great
for my situation.

Before getting your reply ... I had included a routine in the
Valid method for the "agency#" field to show the Agency Name
(via the messagebox function) whenever the user pointed the mouse
to that field. Your procedure just makes it simpler and more
functional for my Grid.

Once again, thank-you ... and as they say in Hawaii ...

Mahalo Nui Loa!

Glenn