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
FoxBert - King of the FoxPro Universe!