Hello, I'm working with Nintex forums and I've ran into a problem that I can't figure out. My form (on a different list and is acting at the main form) currently has two list lookups which are connected to one list named currencies. In the currencies list, there is a currency and amount value. Currently, when the user fills out the forum they pick a currency and an amount, independently. For example, they can choose currency "X" and amount "Y". What I want is for the amount lookup to be filtered based on the currency they picked.
For example, If the user picked "USD" as their currency then the second list lookup should say "5", "10", "20" .... but if they choose "EUR" then I want the second list lookup to display "4", "8" , "12".....
Is there a way to make this dynamic relationship with Nintex Forms or a relationship setting in the lists?