Pick data based on another data selected

[jikasef]

I have a table (courseholes) where each hole has Hole a Par and Strokeindex

I want a situation where, if a user selects any particular hole, the StrokeIndex is populated in a coloumn in another table (HolesScores)

[Jeff_Hager]

You would probably need to write the course index and hole in that other table, create a query filtered by those two values, and then create a lookup column to retrieve the strike index from the query.

[jikasef]

Pls can you explain a little more

[Jeff_Hager]

How is a user selecting a hole. Where are you writing that selection?

[jikasef]

Yes
The user selects a hole, enters score, and clicks next hole. Score is captured in match score table (on click the hole number and score is passed to hole score table) for live view of the game.
Based on the hole selected, I want to use the strokeindex to do a calculation with the score to get net score

[Jeff_Hager]

Are you using a choice component or something else to select the hole? The reason I ask is because I see that you have a course ID, so hole numberon it’s own won’t allow you to identify the correct hole on the correct course, unless you are also writing the courseID to the score table as well.

I guess really my question is, do you have enough information in the score table to identify the correct row in the courseholes table? If you do, then you can create relation or query in the score table to link that row to the appropriate row in the holes table. Then create a lookup column to retrieve the stroke index from that relation or query. It would be helpful to see what information you have available in the score table to see if it’s enough to link back to the holes table.

[jikasef]

Worked like a charm.
Thanks a lot