Hi everyone! I’m afraid it will be a bit difficult to explain but I’ll do my best.
I have two tables (image 1 and image 2).
The first represents a group with its participants while the second represents the reservations made by each individual player.
I would like a number to be automatically created that matches the player’s position in the “Player Name” field of table 1 when a reservation is made.
If for example the player’s name is in third place I would like the player to be assigned ID 3 when making a reservation.
Thanks everyone for the help!