Oracle Apex - Optional List of Values (LOV)

Question

Hi,

Is there a way in Oracle APEX to use a list of values or select list but do not force the user to select an item and allow them to enter different items?

The basic functionality which I require is similar to a combo box where you can optionally select an item from the list or enter a completely new.

Thanks Mark

Answer 1

Yes:

1. you could use a Popup LOV item type, where the user can type anything they want, and the LOV is only used to give them suggestions if they click the LOV button.

2. you could use a Select List, and set Display Null = Yes; but then the user cannot enter their own values.

Answer 2

1. You could use a Popup LOV and UNION it with the values already entered into the target table. It would be slower and ordering would be more constrained.

2. For large tables you could have a process that compared the distinct set of values in the target table with those in the lookup table and entered new ones into the lookups table.