specifik value in one field should delete value in another filed?

[LasseJ]

Hi all

Can anyone help me with this one: From time to time I import Excel-files into a field named, "Status".

I would like to know if its possible to automaticcaly delete any data in another field, (called "Payment Method") if the imported data in "Status"-field are, f.ex: "Not member"

Regards

Lasse

[mr_vodka]

Allow Payment Method to have an auto-entered calculation of Case ( Status <> "Not member"; Payment Method )

[LasseJ]

That did the trick. Thank you very much, mr_vodka!

Regards

Lasse