I am using Airtable as a database for a sports team. Ultimately I will be placing this data on a website. I need to be able to track player stats in a table, and then career stats in another table. Is there a way for two tables to talk, and automatically add the career stats?
Lets say I have three tables… Teams… Player (Current Season)…And…Player (Career Total)
Can current season and player communicate? Is there a good way to organize this data?
I am very new to this… Any suggestions are helpful…