I want help in creating the FMS Query that can create dependency between fields in the system, for example, the value in field X influences the value in field Y. Both the fields are in same Table of database. I did some FMS but below specific case is making bit problem for me.
Basically the both fields i m working on are UDFs and both are Drop down lists, One having around 6 values and other one has 10 values , and on selecting value1 from field1 it will have to select value1 in field2.
This case is making problem, Can I get solution of it??
Can I get an example query on this??
Thanks in Advance