Order Time Tracking

[aladrach]

I think I may have been going about this the wrong way, so I'll see what you all think would be best.

I need to make a system that tracks the time required to make a part, as well as a way to check the current status/location in our warehouse. Additionally, it needs to be an easy to use frontend, as any data entered will be coming from a barcode scanner.

So the fields I want are: Order Number, Part Number, Employee ID, Item Location, Start Time, and Finish Time.

What is the best way to collect this data? I've been advised to use three separate tables (Orders, Items, and Times) but I'm not sure how to link them together.

Any suggestions?

Thanks!

 

[GinaWhipp]

This should get you started...

tblOrders
oOrderID (PK - Autonumber)
oInHouseOrderID
oEmployeeID (FK - Link to tblEmployees)

tblOrderDetails
odOrderDetailID (PK - Autonumber)
odOrderID (FK - Link to tblOrders)
odPartID (FK - Link to tblParts)
odStartTime
odEndTime

tblParts
pPartID (PK - Autonumber)
pDescriptionn
pLocationID (FK - Link to tblLocation)

tblLocation
lLocationID (PK - Autonumber)
lLocation

tblEmployees
eEmployeeID (PK - Autonumber)
eFirstName
eLastName
etc...

Might also help to review...

Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page...
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials
Sample data models...
http://www.databasedev.co.uk/table-of-contents.html