>>Hello All,
>>I have a requirement to produce a drop down combo, that displays a field from a table, and allows the user to add a record by typing directly into the combo and hitting enter, any ideas would be appreciated as I don't have much time
>>
>>TIA
>>
>>Pete Kane
>Pete,
>There is a sample in Tasmanian Traders. A quick and simple coding could be :
>

*Combo lostfocus
>this.value = this.displayvalue
>if !seek(upper(this.displayvalue), "myLookup","UpperedLookupTag")
>  insert into myLookUp (lookupfield) values (upper(this.displayvalue))
>  insert into myTable (myField) values (mylookup.lookupfield)
>endif
>this.displayvalue = this.value

PS: Not tested, might need corrections.
>Cetin


Hi Cetin,
long time no hear, thanks, BTW why the two inserts?


Regards

Pete