setting field from dropdown list

[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