Dynamic Time Log

[Fred in Thailand]

Hello All,

I have a time log db that works well. Now the boss would like it to operate as if it were one of those magnetic boards that are used to track in and out status. I am sure it can be done, but I haven't got any idea where to start.

In the attached file there is a table called TimeLog. It track the time a person logs in and out... (Obvious LOL) I would like a layout that lists all Employees and there real current status. It also needs to update dynamically as they log in and out during the day.

Thanks...

Lost in Thailand

SupervisorLog_V2_Clone.zip

[Fred in Thailand]

Okay, I now have added another layout... Status board.

It gives me exactly what I want except for one thing.

The DB is hosted on FMS 8. Multiuser environment.

If the boss logs on and has the file open on his desktop with the Status Board layout showing and someone logs in and updates there current status I want the boss's Status board to update also.

I have tried Commit records but that doesn't do it.

Thank you

Fred

TimeLog_Clone.zip