I know it can be done..!

[MYK]

Hi

I'm pretty sure this is easy, but I've been staring at it so long I've completely lost the plot. I'm putting together a staff database and I'm stuck on the payroll entry section.

I need to be able to enter a week ending date and then be presented with a list of current employees for which I can just go down the list and enter amounts into a field.

I hope that makes sense. If anyone can help it would be greatly appreciated.

Many thanks!

[BobWeaver]

I don't know how your database is structured, but at the very least, you should have a table for employees, and a table for weekly pay records. In the pay records table there will be a record created for each employee every pay period. I've attached a quick and dirty example file.

PayrollExample.fp7.zip