I have a form which has  several fields.But there are two lookup fields which are looked up from same field Fips code like Fips-01 and Fips-02. you can see below screenshot . 

What I am looking for that I want to update the Fips-02 field on User input of Fips-01 . Say if user enters the value - 1001 in Fips-01  then this value  should not  appear in the Fips-02 .

 So finally in the Fips-02  should have only 1003,1005,1007 .

 

It is possible to do that in creator ?

Arfater.