Gene McFadden

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

Thanks much - works great!!

Same question as before but with simplified example...using two tables. wo_test inv_test ------- -------- techname techname serialnum serialnum stockdate usedate I enter "techname" , "stockdate", and "serialnum" into inv_test. My technicians use wo_test. I only want the technicians to see "serialnum" for their matching "techname" and only when "usedate" is empty. I created a relationship: techname=inv_test:techname which displays only the "serialnum" matching "techname" which if fine - but I need to filter out all "serialnum" records that have a "usedate".

I am an FMP newbie trying to create a database to track inventory and work orders for a group of field techs. I have created two files, inventory and workorder. The inventory file has: "serial number", "stock date", "pull date", "tech name", and "useage date" fields. The workorder file has "tech name", "serial number" and many other fields. I enter equipment into the inventory db once a week, entering "serial number" and "stock date". The techs come into the shop and update the record, entering "tech name" and "pull date" when they stock their trucks. Once they actually install the equipment for a customer, they need to enter workorder info. I want the "serial number" field only to display records for the "tech name" who is updating the record and where "useage date" in the inventory db is empty. (Equipment not installed yet!) I have the first part working with a relationship. (inventory:tech name = workorder:tech name) When I select "tech name" from a drop down list on workorder, the "serial number" field only shows equipment from that techs current stock. It's the "useage date" part I'm having trouble with. Hope the explanation is OK.