Creating An Employee Register

[Hoopsah]

Hi,

I wonder if anyone can help.

Attached is a sample of a register that we use where we record an employees status.

What I would like is a page where I can have a drop down validation list containing the employees name and the screen would then populate with their absence details

e.g.: Donald Johnstone - 26/04/07 - Half Day, 28/04/07 - Full Day etc

anyone have any clues how I could do this

Thanks in advance