Suggestions for Time Sheet Layout?

[eww]

I'm trying to create a Time Sheet layout where in a form you would enter the EmployeeName, EmployeeNumber, a JobNumber for the job they did work on, and then WorkDate, Hours, etc.



What I'm trying to do is have all this information stored in a table called tblTimeSheet, but on the form I just want the employee to be able to access their jobs. Right now you can go through all the records that have been entered, regardless of which employee it is.

I'm also trying to get multiple job work to show up below the fields of entry, whether through a split form or subform, but of course all I get is all the information for every record listed below.

Would I have to make a seperate TimeSheet table/form for every employee? There's gotta be a better way. Thanks!

[Rawb]

You can just make Queries off the tblTimeSheet Table. The Queries would have WHERE clauses in them that limit the resulting Recordset to only that employee/Job.

Limit to a single Employee:

SELECT * FROM tblTimeSheet WHERE EmployeeNumber=1234

Limit to a single Job by a single Employee:

SELECT * FROM tblTimeSheet WHERE [EmployeeNumber]=1234 AND [JobNumber]=1123

Once you have those Queries, you can build your Forms and Reports based off of them instead of straight off of the Table.