Need suggestion to implement unusual form layout...

[psanche]

Working on developing a screen from a Timesheet table that looks like this:

---------------------------------------------------------------------------
Field-1 | EmployeeName | Field-2 | Field-3 | Hours | Field-4 | ....
---------------------------------------------------------------------------
xxxxxx | | yyyyyy | zzzzzz | 16.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 12.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 12.00 | vvvvvv | ....
---------------------------------------------------------------------------
John Doe | 40.00 |
---------------------------------------------------------------------------
xxxxxx | | yyyyyy | zzzzzz | 8.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 8.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 16.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 8.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 16.00 | vvvvvv | ....
---------------------------------------------------------------------------

Mary Doe | 32.00 |
---------------------------------------------------------------------------
xxxxxx | | yyyyyy | zzzzzz | 8.00 | vvvvvv | ....
xxxxxx | | yyyyyy | zzzzzz | 8.00 | vvvvvv | ....
---------------------------------------------------------------------------

Bob Doe | 16.00 |

Challenge: How do I implement it using the standard form
Header-Detail-Footer when the screen should appear as 1 long
editable/scrollable report with subtotals hours by employee. I thought about
using subforms for each employee but it will look funny especially that the
detail record per employee is varying. It's pretty straight forward to do
this with reports but I can't seem to apply it to forms. I'm open to any
suggestions...

Thanks!
-Paul

 

[Albert D. Kallal]

I would make a side by side layout, where on the left side, you scroll
select the persons name, and on the right side, you show all the details.

You can at least 2 examples of this type of forms here:

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

if you scroll toward the end of the above, you will see a donations screen
example, and on the left is some names, and on the right is details for that
name....