specific Item tracking database

[Villarreal68]

Hello Everyone,

I've been looking at all the fine db samples and advice provided in this forum and they are giving me a huge boost in my new job as a DB Admin.

Since this forum has a very active group and you guys know and done it all, I thought I would ask if anyone out there has done or could give me an idea on how to buid the following db:

I need to create a db that will keep track of a specific item from the moment it comes in 'til it goes back out. This could be weeks in the process.

What happens is that this is a program where people donate old worned out wheel chairs and they get totally overhauled. As the chairs come in they need to be tracked from start to finish to see where they came from (Somewhere in the USA), what process it took to overhaul it (ItemID and Current location [Storage, Repair BIN, Repair Table, Completed Tabe, Outbound Table, En Route to Destination, etc] and status [For parts, fixable, paint room, repair room, completed]) and where they were donated to, a city in some foreign country (Africa, Asia, Mexico, South America, Etc.).

If someone has something I can use would be great, but if not any idea on how to do it best, would be greatly appreciated.

Thanks!

René

 

[dcobau]

A rough-and-ready schema. You will need at least 2 tables:

1) tblWheelchairs: UnitID (autonumber) and check boxes for each step of the overhaul. If a step can consists of more then 1 action then use a combo box.
2) tblCountries: UnitID (linked to UnitID in tblWheelchairs), cboCountries, cboCities.

Dave