I've constructed a database containing an inventory of molding tools. Those molds have historically been referred to with descriptive part names. However, my company has several molds that produce identical parts. This leads to confusion when trying to distinguish one mold from a similar one. To resolve this problem, I've assigned each mold a unique asset number.

What I'm trying to do with this database is, from the main form (the window into the database), allow a user to search the molds by a descriptive part name. The search results pop up in a new form, listing the molds that will produce that part. I would like the user to be able to then select a mold and press a button directing the main form to that record, thereby displaying comprehensive information on that mold.

Thanks for your help.
Rich