Help Setting Up Tiered Architecture

[igendreau]

I'm trying to create a database, thought I knew how I was going to do
it, and found it won't work. Hoping some expert on here can steer me
along the right path.

I need to provide my users with a form for data entry. My hierarchy
is: Job > Location > Activity > Hours. So one Job may have several
Locations, each Location may have several Activities, and one Activity
may have several Hours.

From a table standpoint I think I'm good. I have my one-to-many

relationships built for each table. My plan was to have a bunch of
subforms. I'd build a form for Activites, default view set to
Continuous Forms. Then imbed it as a subform on my Location form,
again setting that form's default view to Continuous Forms. I didn't
have to get very far before Access started cutting me off, telling me:

"You can't view a form as a continuous form if it contains a subform,
an ActiveX control or a bound chart."

So back to square one. I need to provide my users a form for input.
It's fine if it displays just one Job at a time. But on that Job
screen, they need to input multiple Locations, multiple activities for
each location, and multiple Hours for each Activity. If there is a
better way to approach this, I'm all ears....