Overriding Related Fields

[dchuhta]

I have two tables... one is a schedule which pulls employee information from an employee table. One of the fields is an fund source code... normally, we want that info to pull directly from the employee field.. which works perfectly... Every now and again, however, we want to override that fund source and put something different in the schedule table. When we do, however, it changes it back on the staff table... How can we prevent that?

[Søren Dyhr]

http://www.filemaker.com/help/FunctionsRef-315.html comes to mind, but the problem is that it doubles the number of fields involved.

--sd