Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert single select to multi select field

blyzzMay 11 2017 — edited May 31 2017

I have a dropdown list on the data entry form in Apex 5.0 which was single select field earlier and now user wants it make multiselect list.

I had the field "FieldA_ID" as number in the main table to store data from the form and was using lookup table for the fieldA_ID and field_description and primary key for the lookup table was foreign key for the main table.

The issue is that if I make the field as multiselect, the values are being stored as string, so I need to change the data type to varchar2 instead of number.

So the lookup table will have 2 varchar fields, one for the ID and other for the description.

Can I make varchar2 field type as primary key for the lookup table as well?

Thanks,

Blyzz
This post has been answered by Erick Diaz on May 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2017
Added on May 11 2017
#apex-discussions
25 comments
8,272 views