Form with a large number of fields

[Guest]

I am designing a form with 140 "blocks" of the same four fields. Each of the
140 blocks is a location (or compartment) in a drawer. The fields in each
block are Item number, Description, Inventory type, and Quantity on hand.
Each "block" of four fields corresponds to a drawer compartment in a vidmar
drawer (type Stanley Vidmar in Google for vidmars). There is also a field on
the form that labels the drawer as a whole. My basic question is how do I
put this many fields on a form and tie them to the drawer label field? If I
have 140 "blocks" times four fields per block, this comes up to 560 fields on
the form. This is supposed to be a form that gives the user a snapshot of
all of the parts in each compartment in a drawer. There are 15 drawers in
the vidmar, so there would also be 15 drawer labels. I am sure a query is
invloved here somehow. Please go easy on me , I am a beginner at this.

 

[Joseph Meehan]

I am designing a form with 140 "blocks" of the same four fields. Each
of the 140 blocks is a location (or compartment) in a drawer. The
fields in each block are Item number, Description, Inventory type,
and Quantity on hand. Each "block" of four fields corresponds to a
drawer compartment in a vidmar drawer (type Stanley Vidmar in Google
for vidmars). There is also a field on the form that labels the
drawer as a whole. My basic question is how do I put this many
fields on a form and tie them to the drawer label field? If I have
140 "blocks" times four fields per block, this comes up to 560 fields
on the form. This is supposed to be a form that gives the user a
snapshot of all of the parts in each compartment in a drawer. There
are 15 drawers in the vidmar, so there would also be 15 drawer
labels. I am sure a query is invloved here somehow. Please go easy
on me , I am a beginner at this.

This sure sounds like a case of bad table design.

You likely need to normalize your table. Any time you see repeated data
in a record it usually means you need an additional table.

Failing to do so will only create more problems later.

It is called normalizing your data.

Split a table into related tables

1.. On the Tools menu, point to Analyze, and then click Table.
2.. Follow the instructions in the steps of the Table Analyzer Wizard.