Hi,  I raised this on Tuesday Ninox Webinar and sorted it out using the conventional related table look up method but I am trying to use, for the first time, a dynamic choice field.

I have two related tables.

The Dynamic Choice field is in Snag Reports and retrieves info from Project Equipment thus:  select 'PROJECT EQUIPMENT'

I need to filter the records in Snag Reports to match the Room number in both tables.  That is to say - I have picked the room the snag applies to and now I need to select the piece of kit in the corresponding room in Pro Equip.  I have a formula in both tables 'room-ID' to serve this purpose.

I cannot work out how to write:  select 'PROJECT EQUIPMENT' (where room-ID) matches room-ID in 'SNAG REPORTS'.

In the related table method I constrained as such:
 

Any help would be appreciated.