>>>Please forgive me if this has been addressed before but:
>>>
>>>In this example I have two tables.
>>>
>>>Table 1 looks kinda like this:
>>>
>>>Company Price Qty
>>>0001 5.00 100
>>>
>>>Table 2 looks kinda like this:
>>>
>>>Company Description
>>>0001 Johnson Widget Emporium
>>>0002 Phil's House of Steaks
>>>
>>>As you can see, I link the two tables via the Company field. The problem I am having is that I want to put table 1 into a grid and then have the user see the Description field of table2. When the focus comes to the company field I want to have a drop down list of the available companies from table 2. How do I do this??? I am stumped at the moment and could use some friendly help!
>>>
>>>Thanks!
>>>Keith
>>
>>Add a combobox to the first column.
>
>I have already done that. I add a combobox to the column, and when focus is on that column, I get the list of descriptions that I want and the combo box fills in the proper company ID into the company field in table1. The problem is that when focus leaves that column, the field that is displayed is the company ID field. Anyone have any suggestions?

if this grid is for viewing only, follow tom's advice...