AnsweredAssumed Answered

Linking price database

Question asked by NormShea on Apr 24, 2012
Latest reply on Apr 25, 2012 by philmodjunk

Title

Linking price database

Post

This is probably a pretty basic question but here goes.  I have a Parts Inventory database with fields that include Item Description, Part Number and Cost.  I also have a Equipment Maintenance Inventory database with a fields relating to repair history.  The Equipment Maintenance Inventory database has a Part Number field as well.  What I would like to do is be able to enter the part number in the Equipment Maintenance Inventory database and have it pull the Item Description and Cost from the Parts Inventory database.  I have the relationship between the two databases established and I can get it to work for the first part number.  What I can't figure out is how to get it to work for successive part numbers.  Can anyone provide me with any direction or suggestions?  I've included an image of the Equipment Maintenance Inventory database

Thanks,

Norm

Equipment_Maintenance_dB.png

Outcomes