September 17, 200322 yr Newbies I have two files - one tracks inventory and the other contains customer work records. The pertinent fields are: workorder --------- Tech name Type of equip Serial Nun Date inventory --------- Tech name Type of equip Serial Num Date Stocked Date used The "inventory:Date stocked" shows when the tech picked up the equip from the shop and put it on their truck. Currently I am using a concated field (Tech name & Date Used from "inventory") to get a dropdown list in "workorder" so the tech can select only what inventory(Serial Num) he/she carries on their truck. I would like to be able to update "inventory:Date Used" based on "workoder:Type of work" - which is a dropdown list that I created. install trouble ticket upgrade deinstall Move Only when it is an "install" or "trouble ticket" should the "inventory:Date Used" field be updated showing equipment used. Thanks
Create an account or sign in to comment