I
Igorin
Hello,
I would greatly appreciate if you could help me on this.
Situation:
I have a Form with 5 Subforms. Of these 5 Subforms, 3 should be subordinate
to the first Subform. The first Subform is linked to the other 3 Subforms by
the field "Work Area" (which is not unique). The 5th Subform is not linked to
the first Subform, instead it is linked directly to the Form by the field
"Report Nr".
The Form is linked to all 5 Subforms by the field "Report Nr" (Primary Key
in the main table).
Problem:
I would like all 5 subforms to be single form and I need: a) that when I
introduce a new Work Area in the main Subform automatically new input boxes
appear in the 3 subforms that are linked to the main Subform; and b) that
when I introduce a new Report Nr every field is new.
Further information, in case it might help...
This form is for inputting information I get from a daily Excel report.
The report for which this DB was created has the following data:
- Report Number (Appears only once, at the beginning of the Excel report)
- Date (Appears only once, at the beginning of the Excel report)
- Supervisor (Appears only once, at the beginning of the Excel report)
- Manager (Appears only once, at the beginning of the Excel report)
- Work Week (Appears only once, at the beginning of the Excel report)
- Work Area (there are 8 work areas, and in one day some - but not all -
appear in the report, and they may appear mor than once. Each time one
appears it has it's own column)
- Work Area Specific Data 1
- Work Area Specific Data 2
- Work Area Specific Data 3
- etc.
-Data for each work area (Each has it's own row and it's in the column for
it's corresponding reported Work Area): start time (i.e., 4:05 p.m.), end
time, activity 1 time (total amount of time invested in this activity),
activity 2 time, activity 3 time, etc.
- Production Data (for each reported work area): Prod data 1, prod data 2,
Prod data 3, etc.
- Statistical Data (for each reported work area): Stat Data 1, Stat Data 2,
Stat Data 3, etc.
- Data that is not work area related: Total fuel consumption, Equipment
used, Total labor, etc.
The Excel file may look something like this:
Report Nr
Date
Supervisor
Manager
Work Week
Work Area 1 | Work Area 2 | Work Area 3 | Work Area 2 | (etc.)
|
WA 1 Sp D 1 | WA 2 Sp D 1 | WA 3 Sp D 1 | WA 2 Sp D 1 | (etc.)
|
WA 1 Sp D 2 | WA 2 Sp D 2 | WA 3 Sp D 2 | WA 2 Sp D 2 | (etc.)
|
WA 1 Sp D 3 | WA 2 Sp D 3 | WA 3 Sp D 3 | WA 2 Sp D 3 | (etc.)
|
(etc.) | (etc.) | (etc.) | (etc.)
| (etc.) |
.. . . .
I would greatly appreciate if you could help me on this.
Situation:
I have a Form with 5 Subforms. Of these 5 Subforms, 3 should be subordinate
to the first Subform. The first Subform is linked to the other 3 Subforms by
the field "Work Area" (which is not unique). The 5th Subform is not linked to
the first Subform, instead it is linked directly to the Form by the field
"Report Nr".
The Form is linked to all 5 Subforms by the field "Report Nr" (Primary Key
in the main table).
Problem:
I would like all 5 subforms to be single form and I need: a) that when I
introduce a new Work Area in the main Subform automatically new input boxes
appear in the 3 subforms that are linked to the main Subform; and b) that
when I introduce a new Report Nr every field is new.
Further information, in case it might help...
This form is for inputting information I get from a daily Excel report.
The report for which this DB was created has the following data:
- Report Number (Appears only once, at the beginning of the Excel report)
- Date (Appears only once, at the beginning of the Excel report)
- Supervisor (Appears only once, at the beginning of the Excel report)
- Manager (Appears only once, at the beginning of the Excel report)
- Work Week (Appears only once, at the beginning of the Excel report)
- Work Area (there are 8 work areas, and in one day some - but not all -
appear in the report, and they may appear mor than once. Each time one
appears it has it's own column)
- Work Area Specific Data 1
- Work Area Specific Data 2
- Work Area Specific Data 3
- etc.
-Data for each work area (Each has it's own row and it's in the column for
it's corresponding reported Work Area): start time (i.e., 4:05 p.m.), end
time, activity 1 time (total amount of time invested in this activity),
activity 2 time, activity 3 time, etc.
- Production Data (for each reported work area): Prod data 1, prod data 2,
Prod data 3, etc.
- Statistical Data (for each reported work area): Stat Data 1, Stat Data 2,
Stat Data 3, etc.
- Data that is not work area related: Total fuel consumption, Equipment
used, Total labor, etc.
The Excel file may look something like this:
Report Nr
Date
Supervisor
Manager
Work Week
Work Area 1 | Work Area 2 | Work Area 3 | Work Area 2 | (etc.)
|
WA 1 Sp D 1 | WA 2 Sp D 1 | WA 3 Sp D 1 | WA 2 Sp D 1 | (etc.)
|
WA 1 Sp D 2 | WA 2 Sp D 2 | WA 3 Sp D 2 | WA 2 Sp D 2 | (etc.)
|
WA 1 Sp D 3 | WA 2 Sp D 3 | WA 3 Sp D 3 | WA 2 Sp D 3 | (etc.)
|
(etc.) | (etc.) | (etc.) | (etc.)
| (etc.) |
.. . . .