Multiple request for parameter value.

[howie]

Hi,

I am using my database that I created as a job form tracking system. Every
page of the hard copy form is a table in the database. I use a formID to
coordinate all the data, so that when I want to view or edit a complete
document I get all the information that belongs to form #1...so on. Now I'm
working on the report. I have a main form with 7 subforms. I am getting
prompted for the formID 8 times(1 for the main form, and 7 for each subform)
how to I dix this problem?

 

[Jeff Boyce]

Howie

I'm have some trouble envisioning your data structure. When you say "every
page ... is a table", that sounds like you started with the pages and forms,
then created the tables to match.

If so, this is exactly backwards from how you make the best use of a
relational database like Access. So what, you ask? So you'll find that
both you and Access have to work overtime to overcome data that isn't
well-normalized. If "normalized" and "relational" are unfamiliar, plan to
spend some time working your way up this learning curve...

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[howie]

Sorry I wasn't very clear there. I meant every page of the actual hard copy
document became a table. For instance, I have a job task table with the date
the task was assigned, the division it belongs to, the name of the task, the
name of the person who assigned the task, and the steps to complete the task,
and the formID to corridinate it with the other data.