yes, thanks you @Saul_Garcia, in particular the use of the third table, as this is something I was trying to utilize here:
Connecting Lookup Tables via Join Row?
to associate the “adjoining” tables’ data via the “middle” table.
I have to say though as much as I appreciate these solutions, way over my head. Most of you here in the community are probably crack engineers in your day jobs, respect! But unfortunately for me as somebody trying to build the basics of my team app without the use of a developer, this doesn’t really make me think I will be that successful with what I want to accomplish without a Herculean effort to master all the subtleties of Coda!
Cheers!