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