Dynamics Community Forum Thread Details

Display Media (or BLOB) on page based on selection in a different field

I have a question on something that I'm sure is possible, I just haven't figured out exactly how to code it yet.

I'll explain using a simplified example:

Lets say I'm a green-grocer and sell all sorts of varieties of apples, bananas and oranges. I want a generic image of an apple, banana or orange displayed on my Item cards based on the selection of some field.

To keep it simple and separate from all other BC stuff, lets say I add a new option field [Product Type] with the options 'Apple', 'Banana' and 'Orange'. So when I select 'Apple' the image of an apple is displayed on the Item page.

Now I understand I can just upload the image of an apple into the existing picture field on the item card, but if I had 100 varieties each of apples, bananas and oranges I don't want to have to import the same 3 images 300 times. I'd rather just set the Product Type and the image displays accordingly.

I'm thinking I'll be using either the MediaSet system table, or given the smallish number of images perhaps just create a new table ProductType which stores the Image along with their corresponding Product Type Code.

Thanks in advance

Quick Links