Art;
You could relocate the "service group" field to the detail table and generate multiple details off of the work order table.
Another penny's worth
Walter Griffin
--- In MS_Access_Professionals@yahoogroups.com, Art Lorenzini <dbalorenzini@...> wrote:
>
> I was thinking about this and don't think that will work quite right because a single workorder could have several different service group type associated with it. Such a plumbing and electrical.
>
>
>
>
> With warm regards,
>
> Arthur Lorenzini| SQL Server/Access Developer l alorenzin@...
> Office: 605-338-0947| Mobile: 605-857-9137 | Fax: 605-338-0947
> Â
> 1316 E. 7th Street
> Sioux Falls, SDÂ 57103 Â
> SQL Server Development
> Database Adminstration Services
> Microsoft Access Development Â
> Grant Writing TA Services
> IT Assessment Services
> Software Application Training
>
>
>
>
>
>
>
> From: Pamela Zimmerman <pzimmer@...>
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, May 25, 2011 11:26 AM
> Subject: RE: [MS_AccessPros] Re: Setting up a work order module
>
> Â
> Hi Art-
>
> Instead of 'ServiceRequested' text field consider converting that to a
> service memo field and adding a Service table with a drop down, so that over
> time you would be able report/assess the type of work being done in
> aggregate. I might even add a ServiceGroup table and assign each service a
> group such that might be useful for you in negotiating contracts, looking at
> trends, etc. For example plumbing (service group) and sink plugged, toilet
> broken, washer not draining, etc. (services belonging to that group).
>
> In terms of time, if you have start time and end time could you calculate
> time rather than store a value in the totalTime field? It has been my
> experience that storing anything that can be calculated usually leads to
> problems.
>
> Pam
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of nkpberk
> Sent: Wednesday, May 25, 2011 10:54 AM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [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
> <mailto:MS_Access_Professionals%40yahoogroups.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
> >
>
> [Non-text portions of this message have been removed]
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar