I have a list named Network Carrier Master with the following columns: Country, Network, Current Carrier, Current Rate
I also have a form with similar fields: Country, Network, Current Carrier, Current Rate. The first 2 fields (Country and Network) are lookup controls and they work as I expect (the lookup lists are separate from the above list). Now I want the other 2 fields; Current Carrier and Current Rate to work such that once the user has selected Country and Network, a lookup function will search the above list and return Current Carrier and Current Rate. In other words
SELECT Current Carrier, Current Rate
FROM "Network Carrier Master"
WHERE Country ="NamedControl_Country" && Network = "NameControl_Network"
I tried using Lookup function but did not return desired results. Here's a snippet of my form