Design Question

[Bunky]

I have a client who wishes to have 42 areas on the form in which he can enter
the number of calls verified per day. His team is supposed to enter the
number of each area they have done on a given day. He wishes to have all 42
shown all the time and the agent will enter 5 for this area and 23 for
another area. I did not want to have a table with 42 areas (all different)
as it makes the table too wide.
Any ideas on how I can design this that will be palatable to me and give him
what he wants?

 

[pietlinden]

I have a client who wishes to have 42 areas on the form in which he can enter
the number of calls verified per day.  His team is supposed to enter the
number of each area they have done on a given day.  He wishes to have all 42
shown all the time and the agent will enter 5 for this area and 23 for
another area.  I did not want to have a table with 42 areas (all different)
as it makes the table too wide.
Any ideas on how I can design this that will be palatable to me and give him
what he wants?

Are they distinct areas? Why not just use a continuous form with

[Area dropdown] [number of calls verified]

 

[Coffee Gal]

Does he need all 42 areas on the entry form or only on the report?

I have a client who wishes to have 42 areas on the form in which he can enter
the number of calls verified per day. His team is supposed to enter the
number of each area they have done on a given day. He wishes to have all 42
shown all the time and the agent will enter 5 for this area and 23 for
another area. I did not want to have a table with 42 areas (all different)
as it makes the table too wide.
Any ideas on how I can design this that will be palatable to me and give him
what he wants?

Are they distinct areas? Why not just use a continuous form with

[Area dropdown] [number of calls verified]

 

[Bunky]

First of all, Thanks to all who answered! I love this site!
Yes, he wants to see all 42 at once on the form.
The agents will enter the numbers they do on the form

Steve,

Thanks a bunch! I understand the tbl for the areaid and the tbl for the
Area but could you elaborate a tad on the other table.

Thanks

 

[Bunky]

Steve,

I'm sorry it took so long to get back with you; family emergency!

Anyway, to get down to it.

I have to show 42 resorts and their IDs on a form then allow the clients to
enter numbers of how many were verified that pertain to 3 different exchange
companies. The way mgmt wants this to work is the clients will select their
name from a pull down (combo box), the date will be prepopulated, then they
will enter number for all the resorts they worked on.

I have made a query to populate the combo box.

The first table contains the resort id and the resort name. This is in a
continous subform. The second table contains the counters for each resort by
exchg company. I'm thinking I have designed this wrong and am working on it
but would like your input.

Thanks