"Dynamic" form

[Trev]

Hello all,

I need help designing a form. The form is used to assign personnel
(variable number) to a job, spanning a variable number of months. In
my mind, the form would look like this:

job combo box

Month (variable #, based on # of job months remaining)
employee % allocation $ allocation (calculated)
^
|
(variable, depending on # of employees)


The best idea I have yet had is to have a series of subforms for each
month and simply hide the ones not being used. Each sub form would
look like
Month
% $

But, what I really need is a way to do a datagrid type of control with
a variable number of both columns and rows. I also considered a pivot
table, but I nned to be able to enter data into the form, and I did not
see how to do that under a pivot table. Can any one offer some ideas?
Thanks in advance for the help.


Trev

 

[mmellring]

Hello all,

I need help designing a form. The form is used to assign personnel
(variable number) to a job, spanning a variable number of months. In
my mind, the form would look like this:

job combo box

Month (variable #, based on # of job months remaining)
employee % allocation $ allocation (calculated)
^
|
(variable, depending on # of employees)


The best idea I have yet had is to have a series of subforms for each
month and simply hide the ones not being used. Each sub form would
look like
Month
% $

But, what I really need is a way to do a datagrid type of control with
a variable number of both columns and rows. I also considered a pivot
table, but I nned to be able to enter data into the form, and I did not
see how to do that under a pivot table. Can any one offer some ideas?
Thanks in advance for the help.


Trev

 

[TC]

For some reason (Trev) your post does not have a Reply buton in google
groups. So I'll hope in on the end of mmellring's reply, which seems to
be empty anyway!

You'd do best by describing your table structure before you ask about
the forms. For each of the relevant tables, list the main fields, and
clearly show which one(s) are the primary key for each table.

HTH,
TC