Report problem

[Jen]

Hi Guys,
I have a form where you can enter employee details. Each employee has to
be trained on 9 different jobs so there were too many controls to fit on a
single form, so i created a Tab Control to split it up into manageable
sections.
Altogether there's about 150 controls and when i try to create a report
based on the form, i'm told i've too many controls etc. I actually only need
to print the details from one of the 9 tabs at a time and the whole thing has
become a bit of a mess. Would anyone have a suggestion as to how i could
overcome this problem.

Please bear in mind i'm an amateur at this.

Tghanks guys,
Jen

 

[Jen]

Hi Guys,
I have a form where you can enter employee details. Each employee has to
be trained on 9 different jobs so there were too many controls to fit on a
single form, so i created a Tab Control to split it up into manageable
sections.
Altogether there's about 150 controls and when i try to create a report
based on the form, i'm told i've too many controls etc. I actually only need
to print the details from one of the 9 tabs at a time and the whole thing has
become a bit of a mess. Would anyone have a suggestion as to how i could
overcome this problem.

Please bear in mind i'm an amateur at this.

Thanks guys,
Jen

I've just been thinking it over......should i have the details of each job
in separate tables and linked together using relationships ?

 

[Duane Hookom]

I think you have a normalization issue. "9 different jobs" should create at
least 9 different records in a related table.

 

[Jen]

Yes i think you're right.....part of the problem was i 'inherited' this
database about 75% complete and it looks like the guy was heading in the
wrong direction with one or two things. I'm going to split the jobs into
different records and pull them together with a query when necessasry.

Thanks for your help on this,
Jen