Populating a table from another table based on a field entered

[Devon]

Hello

I am attempting to create a resource database for my team within my company.
For ease of use (and to speed up all the data entry), the managers would
like to have a template of the various known schedules.

What I am envisioning is a couple of tables, where the manager would enter
the various schedule possibilities in tblA, followed by the schedule of each
employee in tblB.

At the present time I have a tblProject, tblLocation, tblVersion, tblDate,
and tblActivity. Everything appears to be working the way we like. What I
am thinking is that perhaps on the tblDate table, I would add another field
for schedule. It would have a list of all the schedules available from tblA.
Depending on what choice is made, an If/Then statement would run and copy
the data from tblB to the tblActivity. If the manager needed to tweak the
data, they could always go into tblActivity and update as needed.

Can someone please help me with this? As the database stands right now,
everything within the database is easy to update and maintain. I am hoping
this will be something as simple as what I have described, as I can see
numerous schedules being added and updated as things change and employees
come and go.

Thanks in advance.

Devon