Subform delimma

[T. Wilson]

I am building a database of employee records. On one of the tabbed sections
of an employees data, I would like to display his/her current time card.

The time card data is stored in a table constructed as follows:
ItemID Autonumber
EmployeeID Integer
Date Date
TaskID Integer
TimeSpent Double (overkill here I know)
Paid Yes/No

My main table, of course, stores the employee id, so that could be used to
link these two tables. From there, I would like a representation similar to
a time card, so that my display would look something like the following...

Date
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
----------
TotalTimeSpent for this day
Date
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
TaskID TimeSpent
----------
TotalTimeSpent for this day

etc., etc., until the end of the period and then...
=======
TotalTimeSpent for the period

Seems as though this is easy to do in a report, when you can create groups
on the report itself, but I'm at a loss to understand how I could do this on
a form. Any suggestions?

Todd Wilson

 

[Guest]

----- T. Wilson wrote: ----

I am building a database of employee records. On one of the tabbed section
of an employees data, I would like to display his/her current time card

The time card data is stored in a table constructed as follows
ItemID Autonumbe
EmployeeID Intege
Date Dat
TaskID Intege
TimeSpent Double (overkill here I know
Paid Yes/N

My main table, of course, stores the employee id, so that could be used t
link these two tables. From there, I would like a representation similar t
a time card, so that my display would look something like the following..

Dat
TaskID TimeSpen
TaskID TimeSpen
TaskID TimeSpen
---------
TotalTimeSpent for this da
Dat
TaskID TimeSpen
TaskID TimeSpen
TaskID TimeSpen
TaskID TimeSpen
---------
TotalTimeSpent for this da

etc., etc., until the end of the period and then..
======
TotalTimeSpent for the perio

Seems as though this is easy to do in a report, when you can create group
on the report itself, but I'm at a loss to understand how I could do this o
a form. Any suggestions

Todd Wilso


Hi Todd
you could use a subform within a subform. That is the main form shows employee details. The main form contains a subform that contains date details. The date subform contains a subform of timespent

Alternatively, you could use two side-by-side subforms. That is the main form shows employee details. The main form contains two side-by-side subforms. The first subform has date information in datasheet (list) view. The second subform has timespent detail for the selected date. A user selects a date in the first subform and this causes the second subform to show related timespent details (using master/child link fields)

Luc
Jonatha