Calculated value for a field

[dukudee]

I want to calculate the value of my non resident fee field. If the student is a resident, the fee should be 0, if he is a non resident, it should be the non resident fee for the class.

I do it like this:

NonResidentFee = If(Student::Resident = "yes",0,Classes :: NonResidentFee) where classes is the name of a relationship between Student and Classes. Student is the current file.

This does not return anything, but if I put the same line in a script using SetField and create a button that performs the script, it works fine when I click the button.

Can someone help me here, what am I doing wrong with the calculated field?

Thank you

[LiveOak]

In Define Fields, try unchecking the box that says "do not calculate if all fields are empty".

-bd

[dukudee]

Thanks but that did not do it.

Any other ideas?

[Korky]

Check your calculation again.You show the field in the current file as"Student::Resident. The "::" suggests you have selected a related file,not the current file. It should just read If(Resident="yes" etc.