I am currently in the process of moving our tutoring center away from spreadsheets. The first endeavor is setting up our contacts in Airtable. Right now I have student information in one table and parent information in another table and am attempting to link them together. The problem is that many parents and students from different families share the same first and last names. I have ID numbers that both the parents and the students share so linking them together should be easier, but I am having trouble creating a one-to-many link so that one family entry can be linked to multiple students from the student information table.
I may also look for some assistance expanding our record-keeping in Airtable. Currently most of our student data is in various spreadsheets and I am hoping to consolidate that in Airtable. Thanks very much.