Display only groups that a request_for selected user is a member of

[mateuszniew]

Hi all,

I've got a Reference field with sys_user_group attached. Now, I also have request_for field that is a reference to sys_user table.
I want my sys_user_group reference field to only list the groups, that a user selected in request_for is a member of. 

So, if Abel Tuter is a member of Application Development group, the field should only list this one group instead of all of them.

Not sure if sys_user_grmember is better place to link it to.

Many thanks for all help!

[SD_Chandan · Accepted solution]

Hi @mateuszniew,

You can use "sys_user_grmember" table and use reference qualifier as per your requirement.



If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

[mateuszniew]

Thank you very much, this worked!

[mateuszniew]

This has worked. Thank you very much Chendan!