for beginning, sorry for my poor English…
I am in the process of designing an outdoor game and want to count the scores via Ipad, so I am looking for something simple to input.
The teams must choose a “walk” that takes several possible paths. example path: “A”, “B”, “C”
each path counts a number of points:
A = 1
B = 2
C = 3
at the end we add the points according to the walk :
A, B, B, C, A = 9
I first used a table named “path” with a defined score that I linked to my table “team course”, but we can not use a single occurrence of each path, which limits.
and Input on Ipad is simpler with" multiple select …
I explored the possibility of combining the CONCATENATE and SUBSTITUTE,
I also tested with the function IF and OR but I had error messages, I think related to the synthaxe …
I do not think this is very complicated for 3 “PATHS” but a little more complex if you start to have more than 30 different types of score …
Merci par avance