AnsweredAssumed Answered

Filter/Search within drop down field

Question asked by nexgen on Apr 8, 2017
Latest reply on Apr 8, 2017 by philmodjunk

I have a table called PRODUCTS and it has two fields:

 

_kp_products_id

product_name

 

In product_name field it has following values in separate records:

 

iPhone Screen Protector

Samsung Screen Protector

iPhone Charger

Selfie Stick

 

In a layout I want to show the product_name in a drop down field and when the user choose any of the value it should assign _kp_products_id of that product.

 

If I type: "Char" in the field then it should filter down the dropdown with these values:

iPhone Charger

 

If I type: "iPho" in the field then it should filter down the dropdown with these values:

iPhone Screen Protector

iPhone Charger

 

How can I accomplish this?

Outcomes