Job Sheet Assignment & Time Sheet

[jays35]

I want to be able to assign maintenance jobs, maintenance personel and be able to keep track of time. I will have jobs that will require more than one person. How do I create this db and assign jobs and personel.

For example:

Job 1 Tom and Steve 4 hours each

I would then like to be able see a report after a job is complete or the entire list of jobs are done.

 

[beetee]

Just off the top of my head:

Create a table of maintenance personel, with whatever company ID you use as the primary key, and an autonumber field as a unique index. Add whatever other information you need (e.g. name, address, etc.)

Create a second table of MaintenanceJobs, again with some JobID as the primary key, an autonumber field as a unique index, and whatever job related information you need (e.g. date started, date completed, due date, job description, job location).

Create a third table that relates (relational database!) the Maintenance personel and the Maintenance Jobs; call it say JobPersonel. The structure of this table is two numbers (long integers), and individual information for each person on each job (e.g. how long they worked). Make the two long integers the primary key.

Go to the relationships editor, and add all three tables. Create a relationship by dragging the ID field from the Maintenence jobs table to the corresponding number fields in the JobPersonel table, and click the 'Enforce Referential Integrity' check. Do the same process with the Maintenance Personel and JobPersonel ID's.

Create forms for entering Personel and Job descriptions, and Job Assignments. The Job assignments form will be based on the JobPersonel table, and you can use combo boxes to select personel and jobs.

To create the report, define a report based on the MaintenanceJob table, and add a sub-report with details from the JobPersonel table.

Good luck!