So, Kickoffs and Site Visits are both join tables between Techs and Projects? I suppose there's a good reason they can't be unified in one table, say, Activities?
How do you identify/refer to Kickoff records? It seems that what you basically need is a way to identify what Kickoff each Site Visit is related to - so a unique field identifying the Kickoff, which you can then lookup down to Project and from there back up to Site Visits.
Though I have the sense there's something I'm missing about your structure. Conceptually I find it more comfortable to think of Projects as a parent table, with Site Visits and Kickoffs as its children, assigning Techs to the latter two from their own table. That makes it easy to use Project ID as the organizing principle and communication vector for the child tables. I know this isn't helpful, but I'm struggling with the same concepts you are.
It's an interesting question. I'll be curious to see what the pros have to say.
