<snip>

>I have a simmilar issue to the initial problem here... I came up with two possible solutions...
>
>1. A textbox class that displays the single Business Key which was queried via a view parameter. The class would also contain method code to provided a picklist of values, only when the user needed this picklist would the query pull in all the possible selections.
>
>2. A combobox that as is said above is based on a query into an array. In the init, only the matching choice is pulled in... if the user pulls down the combo, a new query is done that includes all the choices... sort of delayed instantiation.
>
>BOb

Bob,

Thanks for the reply - I need the same sort of solution that you have applied in the textbox. We have potentially large numbers of records to be displayed in our foreign key lookups, so we want to move away from combo boxes. Especially as some of these combo boxes require filtered SQL, across a few tables to meet the requirements of the system. We want to use a textbox approach for all our foreign keys, to give the same interface throughout the application.

I know I did this many moons ago in fox 2.x but just need a few pointers in doing it in visual - we're trying to get the main bits of the application woking for this afternoon when the client comes in !!

How does your text box handle changes to the 'visual code'? I take it, the control isn't bound but has some extra property to tell it waht field to update and with what value? - this also has to work in grids????

Any help would be very much appreciated, especially as we haven't got time to look into at the moment!

TIA