Pulling correct image from related database
I have two related databases, one with information on each product we have and one with inspection data on individual products. On the first database there is a picture of each product stored in a container field, I want to make it so that on the second database the correct picture is pulled based on some basic info entered into the second databse.
For example, after entering (in the second database) that the product was from program 3 and variant c, I want to automatically (or through a button) bring over the picture from the matching page (for program 3 variant c) from the first database.
Is this possible in FMPro 12 and how would it be accomplished?