Trouble with more complex interactions

I believe I understand your roadblock, and the fundamental problem is that the form needs to know when to fire the Form Rules to refresh the editable field with the value from the lookup.  

Would you consider adding a radio button multiple-choice field onto the form where  the user chooses to use either the Standard Clause or Override Clause.  

That can give more flexibility to your form rules, because if they select to use the Standard Clause, then the field would be non-editable, and would always be a mirror of the look up field ( ie maintained by form rules). But as soon as they do override, then the field becomes editable at that point. 

------------------------------
Mark Shnier (Your Quickbase Coach)
[email protected]
------------------------------