I have a Form where I generate some short codes using build string function for marketing team.
In the form I have a control called "IO_Number" which has its master in list "IO_Number_Master".
I also have a control named Category which has its masters in list "Category_Master"
There are 9 Categories where each has its Corresponding IO Number.
Each year IO Number changes for those 9 categories.
now I want the IO_Number control to show only the IO Number option in the drop down corresponding to the year and category selected.
In Sql we can write the query as:
Select IO_Number from IO_Number_Master
where year=year && Category==Category.
now which formula to use in calculated field ?