I have a scouting database where I put in player scouting reports. In another table I have a club team information like club name and contact information for the club etc. I want to connect this information to the scouting report so when I select a player and put his report on a alyout that his club information like team and coach name and cell phone can be connected.
In the relationship chart below DT is the main table that has all the player information in it. AAU Coach Directory is where I have the club information , and Event participation is where I have the player scouting reports. How do I connect the AAU COach Directory and event participation table together so I can list the inforamtion in AAU COach Directory in layouts connected to the Event Participation table?