Relationships required for creating forms

[windmi]

I am very new to ACCESS and willing to try and create a time tracking program for my small company.



I have three tables tblProjects, tblEmployees, tblWorkHours. I would like to create a Form to input all data for tblWorkHours and also have employees add some info already enterd in tblProjects and tblEmployee such as Employee name, Project No, Location.

Ultimately be able to print weekly time reports per project or a report showing hours at different locations.

Attached is a relationship diagram i have set already. something is wrong there because when I use them together I can not see data in a query of beable to fill a form.

Any help is appreciated....

[June7]

Show the query statement or provide db for analysis. Follow instructions at bottom of my post.

Why do you have EmployeeID in tblProjects?

[windmi]

I have the EmployeeID in tblProjects so I can keep trak of Supervisor on the Project.

I attached a copy of the DB with Data removed. If you need some data tell me.

This Project started long ago with a template from microsoft office access 2007 Inside Out. Work schedule has kept from this project but know it is need even more to stream line reporting and tracking. I have many areas to address but right now I want to do a time sheet tracking whats noted in tblWorkHours for each employee than get reports worked out later.

One step at a Time

Thank you.

[windmi]

I hope this has the attached DB

[June7]

The PK EmployeeID field in tblEmployees and the PK ProjectID field in tblProjects are number type fields, should they be autonumber?

Why is the PK ProjectID field set up as a combobox with a lookup to Surveyors table?

Lookups in tables incorrectly reference table names.

The lookup for EmployeeID in tblWorkHrs assigns the wrong field as BoundColumn

Review http://access.mvps.org/access/lookupfields.htm

Change qryWorkHoursDetails to:
SELECT tblWorkHours.*, [FirstName] & " " & ([MiddleName]+".") & " " & [LastName] & (","+" "+[Suffix]) AS Employee, tblProjects.Vessel, tblProjects.LocationID
FROM tblProjects RIGHT JOIN (tblEmployees RIGHT JOIN tblWorkHours ON tblEmployees.EmployeeID = tblWorkHours.EmployeeID) ON tblProjects.ProjectID = tblWorkHours.ProjectID;

[windmi]

1. ProjectID & EmployeeID are assigned based on present company policies and assigned manually
2. Dont know - just realized - changed it to a text box is that OK
3. What should it look up?
4. Changed column count to 2 EmploeeID comes up not last name.
5. Will review lookupfields
5. "change gryWorkHourDetails to:" Where?? Sorry.

Maybe I should start from scratch and learn as I go or can this realy be solved and workable with out an expert like you...? What say you...

[June7]

1. Okay
2. Okay
3. tables are named with 'tbl' prefix, the Lookups don't have the 'tbl' prefix
4. you want to hide the EmployeeID column by setting ColumnWidths: 0";2"
5. good
6. this is suggestion for structure of the query, paste the sql into the SQL view of query designer or edit the query with the Design View

Everyone learns differently. I was lucky to already have an understanding of database principles and programming concepts when I started with Access and I also had a face-to-face mentor to rely on.

If you haven't gone through an introductory book with tutorials, might be a good idea, or take a $400 class at university.

[windmi]

Thanks I will consider this complete. Have a great day