I have a form which I enter data specific data into it. What I want to do is to add data into a new field form existing data.
The table shows a award of 1 or 2 up to 6 in a field called placing, this then calculates another field which gives me a figure, for instance 1 in the placing will give me 10 in the points field. These fields are set to numbers in the properties.
What I would like to-do next is to take award placing of "1" and in a new field called "certs print" add "FIRST".
I can't seem to get the command to work, what am I doing wrong or and what is the command.