Samantha This is the picture of our column names in Excel

Are there any Relationships between the Tables?

Samantha Look at Helper Data (https://599cd.com/blog/display-article.asp?ID=1386).  Your ClinicianT, ConsultantT, DirectorT tables could be in one table, with an additional field for type.  Add drop down lists on your ChildFocusedF form for each type, with the dropdown's query distinguishing the proper type.  Only the ID would need to be stored in the table. You may need an event table as the item that glues it together as a child may have multiple events associated.  Step back and map fields, relationships as Richard suggests.  Throw a little sample data in to see how it behaves, revise as necessary.

John Thank you so much! I thought I did but my brain is struggling with applying it to my particular situation. I thought I understood things until I started mine from scratch. I did start to figure this out this afternoon! I think I might be on a good road with your explanation and my connections! Thank you again!

Alex Not at the moment, I'm trying to build them from scratch and got stuck on Friday. Trying to figure out how it will all work before my consultants start entering data.

Sounds to me like building a query would be the next step.