Choice/reference field that will show two fields on choosing choice/reference

[G Balaji]

Hi,

I'm defining a custom table extending from task table.

I've a field which will show the list of choices. Choices will be from another table. While I'm showing up the choices to the end-user, two fields on the reference table has to be shown to the end-user to choose one choice. 

Which data type should I choose to implement above requirement? Choice or reference? 

Is there anything called "lookup" data type? Wil that data type be suitable for this requirement? If so, how do I implement it because I dont' see it as a data type.

Thanks.

[Ankur Bawiskar]

Hi Balaji,

So you have 2 reference fields and 1 choice field.

Based on selection from above 2 ref choice values are to be shown?

Is that correct? Or can you explain your requirement?

Regards

Ankur

[G Balaji]

Hi Ankur,

Thanks for the response.

My custom application will be used by three different end-users. Lets say X,Y and Z. X fills up the form and Y and Z approves it .

Attached screenshot is the choicelist. Form will process the column A but end-user X is aware about the data in column B. Approval by end-user Y and Z will be based on Column A's value. 

Suggest me the best datatype to add it to custom table.

Something similar to the "Reference" field in "Dictionary definintion" when we choose reference as data type.

[puneetgoels1]

Choice field is your best bet. you need to insert this data in sys_choice table

[G Balaji]

Thanks for the response, Puneet.

While making the choice, user may need the data in other columns for reference. Is there any suggestion to show it up in some other means? Like another label field?