Tabular data - How to solve tabular data in relation to Product/Article

[amidoszitac]

We are thinking of what the best practice could be regarding tabular data.

Lets say we have chemical data, that could be an Id, Name, Description and an Image/Icon.

We want to relate this on a set of products and/or articles. But i want to refrain from using Multi-field as this means that the customer has to change the image on all 700 articles using that chemical code. I rather the customer change it in one place and it changes on all 700 articles.

So basically what Im thinking is a classical Field with a value, that points to some form of row in a table. But i want to make sure Im not missing out-of-the-box abilities to solve the issue.

One thought ive had is creating a custom back-office implementation of tabular data, but then the remaining part is having an easy way of pointing to a table and row on articles, so this also feels like it wont be a good user-experience.

tl;dr: Any input of ways of solving classical tabular data with x amount of columns to be pointed to a product and/or article is welcome.

[Martin.Brandt]

I did something like this for a customer, some years ago. It was for warning symbols of different kinds, where each symbol had an icon, title and description/text.

I made an angular panel under the PIM where users can create/update/delete each warning symbol, utilizing the media archive and the image dialog etc and using SettingService to store the List in database.

I then made a custom field that allowed user to select a warning symbol from the list of stored symbols, that field plus a text field was added to a multifield array, so they could select from the list of symbols, plus add a custom text for each product, for the symbol if they wanted.

regards,
Martin