>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
You can run an SQL for unigue values. Make your ListBox data source 'SQL'. This way only the results of the SQL are shown. This is one of several ways.
HTH,
Tom