FMS Query that Can create dependency between fields in the system.

Hello Everybody,

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