To do what you want in a calculation, you would use a Case statement which performs progressive tests.
Something like this:
Case ( Bill > 1800 and Dianne > 1800; "X"; Bill > 1800; "B"; Dianne > 1800; "D"; " " )
The syntax of a Case statement like this is:
Case ( Test1; Result1; Test2; Result2; Test3; Result3; DefaultResult )
The Case statement short-circuits (stops processing) when any test returns true.
This is not really that complex for FileMaker Pro to handle. You just need the correct function and syntax.
Please let me know if you need further help or can't get it working.
TS_Oz, FileMaker Inc.
Thank you for the help. It works once I have corrected my wife's name from Dianne to Diane.