>This is the way that combo's work < s >. All you have to do is include the foreign key value in the combo's RowSource and set the combo's BoundColumn up to point to the column that contains the key value. This tells the combo to use whatever is in the BoundColumn to update the combo's ControlSource.
This concept I have used in simple cbo, okay.
>Of course, if the foreign key is numeric, you also need to set BoundTo to true.
I'll remember thanks.
>Actually the code that I posted is in a custom method of the combo called HandleKey(). Method is called from the InteractiveChange() method of the combo like this:
>
>
>*** handle the key...IOW, find the closest match in the list
>IF This.SelStart > 0
> IF ( LASTKEY() > 31 AND LASTKEY() < 128 ) OR ( LASTKEY() = 7 )
> This.HandleKey()
> ENDIF
>ENDIF
>
Thanks I'll give this new cbo a try. I'll create handle key with the previous code and put this in the InteractiveChange. Is this all for an (more than) equivalant cbo, which I use?
>This Quickfill combo is only one of the useful classes in
1001 Things You Wanted to Know About Visual FoxProI'll keep that in mind <g>.
Appreciating your help, thanks.