Choice list based on list of another table

[Vasilis Anastas]

Hello, 

In case form I want , when I chooce Account , The Assignment group choice list to be filtered based on a custom list field* that I created on Accounts table. 

*List field: I create a custom list on table account that is reference to group.

is there any ideas?? Thank you!

[Community Alums]

Hi @Vasilis Anastas 

You need to create a onchange client script where the reference group field form account will be taken and use it as filter condition for assignment group table.

Please mark it helpful and solution

Thanks

Akash

[Community Alums]

Well, a bit tricky case here.

You can use a reference qualifier on the field (calling either a script include or direct script) or in the field definition to add choice table and choice field + dependency (if needed)

[Vasilis Anastas]

Hello Joro, 

I cant see options choice table and choice field in advance view. I can see only Choice --None--.