Can you create a lookup that populates a field if a partial entry is made?

alex6789

Can you create a lookup that populates a field if a partial entry is made and still be able to do a manual entry?

Is it possible to have functionality where when the user partially types, it filters to those options e.g. blue/green/white and populates with that option. And for the user to also manually be able to enter what they want? Not sure if this functionality already exists

vaprog

Yes, but you need to call your code from the trigger on the page, not from the trigger on the database field. There you get in Text, whatever is in the field when the trigger is called. Also, you should return the value selected in the VAR parameter Text, and indicate succsess or abortion of the lookup with the trigger's boolean return value.

vaprog

Yes, but you need to call your code from the trigger on the page, not from the trigger on the database field. There you get in Text, whatever is in the field when the trigger is called. Also, you should return the value selected in the VAR parameter Text, and indicate succsess or abortion of the lookup with the trigger's boolean return value.