Trying to create some sort of array to put data from multiple columns in one cell

I have a Course Hole Table (for a golf course app) with columns - Hole number/ Hole Par/ Hole Stroke Index.
I want to relate all that information in the table so that I can pull all data per hole in a calculation in another table (Match scores)

1 Like

Create a relation to the hole table, and then add as many lookup columns as you need to pull each column out of the relation.

2 Likes