Filter in a reference field

thirumala2
Tera Guru

HI All ,

 

I need a help in creating a filter for a reference field :

There is a table : f5 devices

thirumala2_0-1710334847797.png

 

in that the ip address are of different environments .

In the other table which the field is referencing to is below : F5 vips

thirumala2_1-1710335002313.png

 

Now the requirement is if environment is non prod then devices which have dev as environment in f5 devices only needs to be visible in the reference field. This environment field is not available in F5 vips table :

How can I acheive that kindly suggest: