I have a table with a.o. a numeric field and a choice field. Depending on the choice made in the choice field I would like to automatically change the value in the numeric field from positive to negative. I have tried with the "trigger" fields but that did not work, at least not for me. I would very much appreciate if someone would point me in the right direction. Thanks in advance for any help. Gerard p.s. this is a first time for me asking a question in a forum so please bear with me if i am not following proper etiquette.
It works. Thanks Steven.