It's possible as this is a basic function of any relational database.
Ideally, your tables should be linked like this:
ProductInfo::__pkProductID = Inspectiondata::_fkProductID
With such a relationship in place the the correct value in _fkProductID, you can add the container field from ProductInfo to your InspectionData layout and it will show the correct image.
_fkProductInfo can be set up with a value list of product ID's and product names/descriptions to use for selecting the correct Product Info record, or a button on the ProductInfo layout can create a new record in InspectionData with the correct value copied via a variable from ProductInfo to the new InspectionData record.
Other, more sophisticated ways for selecting the correct ProductInfo record for a given InspectionData record are also possible.
I ended up doing it differently by using a portal which only displays values of the field for which the variant types are the samel, it seems to work.