Validating Shown Reference Options From Other Reference Field

[Wasdom_Kung]

Hello,

I have an item with two fields:
Manager - references the sys_user table

Requested items - references the requested items table and limits to a specific type of requested item

I want to have the requested items reference field only show requested items requested/opened by the manager name in the reference field above, so that it would filter out requests of the same type by other managers.

What would be the best way to achieve this? 

[Wasdom_Kung]

Still having the issue where it loads all RITMs:

[Vishal Birajdar · Accepted solution]

Hi @Wasdom_Kung 

Please correct the highlighted text like below :

[Wasdom_Kung]

I knew there was something weird with the &colon stuff, I had also seen it in other Google posts so didn't think anything of it.

Thanks Vishal 🙂

[Vishal Birajdar]

Yeah....!! colon gets formatted after pasting in editor.🙃