Might need a little more on your relational structure to help with this question. For example, do you have more than one table? If so, what is the relationship between the tables. I'm imagining a Student and Competition table at the very least but want to make sure. Thanks.
Thanks for taking time to help.
It's only one table with two layouts. One layout for students to enter their answers and one where the answers and points appear.
1 of 1 people found this helpful
It sounds like you want to have each Copper Points field in the record filled in automatically based on the value in the Copper Rank field in the record.
If that is the case, you could use a calculation like the following.
Copper Rank = 1; 3;
Copper Rank = 2; 2;
Copper Rank = 3; 1;
0 // This is the value for any other value of Copper Rank
This could be applied with one of the following:
- a looping script (via Set Field)
- Replace Field Contents... via Calculation
- Auto-Enter value in the Options... of Copper Points
- changing Copper Points to be a Calculation field
I would just like to say a big thank you. Its funny really the answer was staring me in the face.
This worked perfectly.
Thank you to you and anyone else you tried to help.