Filter list field based on another list field values

[G Balaji]

Hello,

We've a custom application running on a custom table where in there are 2 fields of list data type.

Both the list fields refer to different tables.

Based on the values chosen by user in List field A, values of List field B has to be displayed for the user. ie. the filter has to be applied dynamically on List field B table based on the values in List field A.

Any pointers on this?

Thanks.

[gauravchoudhury]

Hi G Balaji,

Did you try using Advanced Reference Qualifier?

Refer to my attached screenshot.

[Harsh Vardhan]

either you can write onChange Client script here to set the filter on list b based on list a value or you can also fulfill this by using reference qualifier.

eg: i have two field which is list type so you can write reference qualifier like below. 

 javascript:'NameIN='+current.<list A field name>.toString()

[G Balaji]

Thanks for the response.

@Harshvardhan I tried using onchange client script but it doesn't meet my requirement completely. List field still show all the values available in the table(without filters).

javascript:'u_data_typeIN='+current.u_data_handled.toString()

also doesn't work. I believe above line of statement refers to server script which won't be applicable for my requirement because we need it in onchange of another field which means it has to be handled at client level.

Any pointers?