Here's what I have done. I made a access database to keep track of parts that
we work on. It mainly tracks the condition and storage location. Other people
keep a database for shipping and one for receiving of parts.

I would like to be able to update mine automatically using information from
the other databases in our company. Example. When a part is sold sometimes
the person who pulls the part for sale forgets to change the condition of the
part from good to sold in our database. I thought it would be better if when
searching for a part and it was sold that the condition would automatically
be changed to sold.