Transmission of a field with Relation inverse

Firstly, thank you very much for your great extension and sorry for my poor english.

I have a category "brand" with a lot of items inside.
I have a second category "product".

I create a field "relation" and "relation inverse" to link each product to a brand.

This is my problem : the price of each product is always the same but different for each brand. So I create a field "price" for each brand.
Now, I want to transmit the brand price for each product (and make a product research per price after). But I don't know how to make that. Is it possible ? I think yes, but I search 3 hours without any success.

Thank you in advance !!
Nicolas

Hello

ok, but, what do you mean with "transmission" ?

do you want to display inside a product, fields of the related brand,

e.g. display "price" field of brand item inside a product item ?

-- for the above there is a custom HTML parameter inside the relation and inside the relation_reverse field, which you can use, please read the popup description of the parameter

Hi,

Thank you but it's not that.

I have average 20 different brands. Each brand sell almost 20 or 30 products with always the same price.

So I want precise the price of each product in the category "brand". Like that, if the price change, I can modify only 1 field and not 30 product.

It's perhaps not possible ... and probably more simple with a SQL request.