Inventory

[directorz]

Hello experts,
I'm incorporating inventory into a db using the NorthWind inventory as a model and my db tracks equipment maintenance. When any maintenance is performed, a work order is always completed, thus I have a work orders table which needs to be tied to the inventory model. The work orders table includes a products or "parts" field. My question is should I link to the 'products' field or the 'transactions' field.

Thank you

 

[ZmrAbdulla]

I don't think a WorkOrder table can have a field called "Products" or "Parts". The reason is a WorkOrder can have one or many products/parts.

So you need to have a table called "WorkOrderPartsUsed" that can have "WorkOrderID" , "PartsID" , "PartsCount"

Hope this helps

________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[willir]

A work order may be treated like a order entry system, or invoice system.

tblWorkOrder
WorkOderID - pk
CustomerCode - fk
StartDate
EndDate
Task
...etc

tblWorkOrder
WorderDetailID - pk
WorkOrderID - fk
PartCode - fk
TaskCode
HoursSpent
...etc

This takes Zameer's idea of using a many-to-many for WorkOrder x Parts, but now tracks details.
Richard