Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2005
    Posts
    3

    Unanswered: Tracking inventory location

    This is what I want to do:
    1. Be able to track where materials are (I have 4 Locations)
    a) I also have up to 25 sublocations at each location
    2. If materials get transfered to another jobsite I need that to be tracked
    3. I have 4 employees that would be working with this data
    4. If possible I would like the field employees to be able to access this data on a pocket pc, then at the end of the day sync this info up to the main data base.

    Is this possible, or have I not made any sense?

  2. #2
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Yes, it's possible and relatively easy.

    The bad news is...
    In my experience, warehouse workers are the absolute worst at data entry.
    Inspiration Through Fermentation

  3. #3
    Join Date
    Mar 2005
    Posts
    3
    Great,

    Its not a wherehouse, but jobsites. Its a construction company, 4 subdivisions with roughly 20 lots each. I need to track where lumber and such goes and where it comes from. I have 2 guys in the field that would be actually imputting this data and then back at the office 1 guy that would be accessing the data (to see where things are, if we are in need of anything) and then the computer guy that is supposed to implement this all. I was hoping I could create some sort of form that could be accessed on the pocket pc's (IPAQ's) that would be easy to use (ie, what product; how many; from where; to where; authorized by). At the end of the day when the guys clock out they could sync the ipaq's to the office database so the office guy could see what is where. How do i do this?

    Currently the have to write this all down on paper, they have a lot of paper work, and im trying to reduce paper and get everything computerized

  4. #4
    Join Date
    Mar 2005
    Posts
    3
    How do you subscribe to a thread?



    Oh

  5. #5
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    I suggest you start by looking here.
    http://www.rogersaccesslibrary.com/TableOfContents3.asp

    He's got plenty of sample databases (free) that should help get you started.

    As far as the pocket PC's go, someone else will have to help you with synchronizing the DB's.
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •