I have a content type "products". Every product has its supplier. The supplier is another content item. To link a supplier to a product, the id of the supplier content item is saved to the product table.
In the product list I'd like to show some details of the product's supplier, e.g. phone number or email address. But: I don't want to "copy" these details to the product's table. I want to link suppliers dynamically. So if the phone number of a supplier changes, it should be shown correctly in all the products.
I know I can solve this by creating requests in a beforerender field. Isn't there a better way?