Default drop down option in custom field

Hi.

I am wondering is it possible to use the key-in values and SQL query method to create a single drop-down in hikashop custom field? Otherwise the product will always get the first option which is not correct.

Hi,

You can use UNION to bind together your MySQL query with another query ouputing one result. You can read more about this here:
stackoverflow.com/questions/12110167/add...f-mysql-select-query