Please can someone help....?

[ellsbells]

I have inherited a Filemaker Pro system which drastically needs updating. I want to be able to link 2 fields together so that when one value changes it immediatly updates the value in the other field. However, I have not been able to do this using the 'if' function as you would in Excell. Does anyone have any tips on how to do this?

FileMaker Version: 4

Platform: Windows XP

[CobaltSky]

Hello ellsbells,

There are a number of ways to do the kind of thing you're describing in FileMaker, and one of them is certainly to create a calculation field and place an If( ) function in it. The formula for the If( ) function in FileMaker is:

If(test, result one, result two)

Whether this is the best method in your case - and if so, how it should be implemented - is hard to say without knowing more about what it is you are trying to do.