Tiered database help

[ian_gendreau]

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....

[Larry Linson]

<ia**********@hermanmiller.com> wrote in message
news:11********************@g49g2000cwa.googlegrou ps.com...

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....

With a little VBA code, not necessarily "clever code", you can include a
command button on each subform to "Enter/edit <whatever's the next level in
the hierarchy>" change that continuous form's view to single form view, and
make its subform visible. You can create a "Back" button to reverse the
order.

Alternatively, you could pop up forms instead of using Subforms.

Larry Linson
Microsoft Access MVP