New form to input monthly data

[rcollins]

I have a small project I need to do. What I would like, is on the form, select the Empliyment Consultant from a list (or from who is currently logged on). Then I want the subform to show an empty record for each client that the employment consultant is conneted to. Here, we will put in the end of the month data that we need. I would like this to be in spreadsheet datasheet view so the EC's can read it real easy. Also, one of the reasons to pull up all of the clients for each EC is so they don't forget to enter for a client or duplicate entries. I usually don't have a problem with setting up tables, but this one got me. Here are the fields that I will need to keep. EC, Client, Hours, Date. Thank you for any help.