Allowing images to be accessed across files

We have a connection ability to share description across files already although i find the method somewhat confused.

If I have a product file with a key to that file of XYZ and that file has a description field

In an application for example we use this in conjunction with a sales file.

1. We should be able to read the description of the product for display along with the code, in a dropdown box but only storing the code on the sales file not the description itself.

2. We also have an image of the product but have no way of retrievng or calling that images in the sales file without storing the image on the sales record or an external link.

Defeats the purpose of having an image in this application in a master Products file.

We should in true relational database fashion be able to access info in connected files other than just text

Would open a whole new ball game for apps