Remove choice from list type field based on the selection of choice field value

[PradeepaM]

Field A - Choice Field - single option select

Field B - List Field (Added choices in the related list) Multi select

Backend:

Field A and Field B has the same choices. If Field A has the options a,b,c and agent selects option a, then option a should be removed from Field B list and vice versa based on Field A selection.

Field B should have the remaining option expect the value selected in Field A.

Any help would be appreciated!

Thanks in advance!

[JenniferRah]

I'm not sure I follow your scenario. A Choice field presents a list of manually entered choices. You see a label, but the field stores a value. For example: 

Label		Value
Label A		label_a
Label B		label_b
Label C		label_c

A List field, though, pulls values from a table and stores the sys_id. For example:

Choice			Sys ID
Abel Tutor		62826bf03710200044e0bfc8bcbe5df1
Abraham Lincoln	a8f98bb0eb32010045e1a5115206fe3a

So, if you want to create a reference qualifier for the List field based on the choice in the Choice field, you will have to have some field in the table that the List field is pulling from that you can use to limit the choices. For example, if your choice field was a list of locations, you could add a reference qualifier to limit the choices in the List field to those where the locations matched your choice. But you need to make sure the value stored in the choice field matches what is stored in the table.

I would have to have more information about your specific tables and fields in order to give any more guidance, but hopefully this clears up a few things about how the data is stored.

[PradeepaM]

Thanks for your time!

Field A - Choice Type (Single option select)

Label		Value
Label A		label_a
Label B		label_b
Label C		label_c

Field B - List Type (Multi option select)

No reference table added to it, instead it holds choice similar to Field A

Label		Value
Label A		label_a
Label B		label_b
Label C		label_c

Field A value is selected as Label A then Field B should not have the option Label A available for selection.

Thank you!

[JenniferRah]

Then the best way to do what you want to do is with a client script that runs when Field A changes. You can clear all the selections from Field B and re-create them, omitting the selected value from Field A. 

The reason you can't just remove the selected value is because they might change their selection of Field A. Users will be users... 

[PradeepaM]

Thanks for the suggestion!