ACCESS FEED: [MS_AccessPros] Re: Setting up a work order module

Rabu, 25 Mei 2011

[MS_AccessPros] Re: Setting up a work order module

Art: For once I shall attempt to contribute Instead of Just asking.

I think You may have to account for more than one employee on some jobs (moving furniture maybe or a safety man when playing with electrical) and that will require tracking time/cost for 2 or more people.

If You contract out often you may want a tblContractors with the usual information maybe fed by a small tblContractorType to populate a drop down field on the tblContractor (electrical, HVAC, Landscape, etc) and then a tblContractDetail with :
WorkOrderID; linked from tblWorkOrder
Contract/InvoiceNumber;
ContactDate;
ContactWho;
ContactBy; linked to Employee table
Estimate; If supplied
SchedStartDate;
ActStartDate;
SchedCompletion;
ActCompletion;
OnBudget: You can track contractor performance on the last 5 fields
TotalCost; link to tblworkorderdetail.costContractedWork
Possibly add an attachment field (2007>) to scan a copy of the invoice so you don't have to hunt for it in the file cabinet.
And Insert into the tblworkorderdetail the Contractor ID/Name field linked from tblContractor

Hope This is helpful just my 2 cents worth
Walter Griffin

--- In MS_Access_Professionals@yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> I am working on setting up a work order module for our unit manager database. Structually I am thinking the following:
>
> tblWorkOrder
> WorkOrderID
> UnitID - the unit the workorder is tied to
> ScheduleID - link to schedule lookup table (Morning, Noon, Evening
> EstStartDate
> EmployeeTookCallID - link to employee table
> PermissionToEnterFlag
> TenantID - link to the Contact table
> ServiceRequested
>
> tblWorkOrderDetail
> WorkOrderDetailID
> WordOrderID - ties the detail record to the WorkOrder record
> Quantity
> Material/Service
> UnitCost
> TotalAmount
> CostContractedWork
> PerformedByID - link to Employee table
> DateCompleted
> InspectedByID - link to contact table
> DateInspected
> TimeStarted
> TimeEnded
> TotalTime
> TotalMateriaLabor
>
> That is all I can think of. Any more ideas? Does someone have an better structure than this that they could share with me.
>
> Thank you
>
> Art Lorenzini,
> Sioux Fall, SD
>