using check box info

[gtag]

I have a table consisting of event locations, which has a check box field containing 9 conditions. Each record therefore has a combination of conditions for each event location.

I have another related table that contains performance data from 200+ events (each event has 45 unique players, rated 1 to 45).

I have a third related table that contains 45 records of people (the same 45 people who are counted 1 - 45 in the performance table).

I am trying to figure out how to determine what conditions each person performs best in. any idea how to do this?

[Vaughan]

The conditions need to be in separate related records, not in a single field as checkboxes. That way they can be associated individually with people.

The conditions need to be related to the locations, which in turn need to be related to the performance data, which needs to be related to the people. That way you'll ultimately get the people-to-conditions relationship you need. From your description some of those relationships already exist in the data, this is good.

There might need to be some join tables along the way, and some data wrangling to make it work.

[comment]

I am trying to figure out how to determine what conditions each person performs best in.

That's a very vague question - it could be interpreted in thousand ways. For example: do you "measure" the influence of each condition in isolation (ignoring possible interactions between individual conditions), or do you look for certain combinations?

Would you know how to approach this problem if you had to do it on paper? If not, there's no use trying to figure out how to do it in Filemaker.