asset tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to track 3 types of devices. They usually reside in a truck (1 truck has 1 of each device). When a device needs to be repaired a shop replaces it with another one, then ships the broken device to a vendor for repair. I am new to Access so I took a look at the Asset Tracking template. it's good for devices that always stay in one spot, but these move around. I not only have to track their current location, but their "history" as well. In the template I can just pick another location from the list (ie change EMPLOYEE to TRUCK and pick from the list) and that keeps me up to date nicely on where the device is, but how can I track the history ? and is there any way to 'move' the device and record the move in history all on the same form/transaction ??
 
ok, i could change the "maintenance" table to "History" and add the Truck field in there somewhere, so when I update that asset i just click on the History (previously maintenance) button and note where it was when I changed its current location. not as smooth as i would have liked, but it gets me up and running quickly to tame an inventory situation that is getting out of control!

anu other (read BETTER) ideas ?
 
Back
Top