Tracking attendance from one table into multiple tables

I am looking to track attendance of multiple sets of people. The setup is as follows: I have 3 tables: "Athletes," "Connections," and "Business," which contain the contact information (We'll call t...