Yes, I try to solve the problem with related articles.
Modul that display a list that search related articles. I used the ckk standard in the search field with the live value of the content type "related_article". The output is: all articles but not from the users article.
I found no solution to display the other articles depend on created by of the main article.
I give you the app. If you want to rebuild that, you will also create a modul with a position "rel" and that displays the list "list all articles" and you have to make a menu that display one of the articles you have wrote with different users.
I made two products and Two producer and linked product 1 with producer 1 and product 2 with producer 2.
Product 1 only shows under producer 1 and
product 2 only shows under producer 2.
Note: In your Search Type; Match should be selected as "Exact". Otherwise if any producer have similar id as the current producer have will also be showing the products of both producers. (i.e producer 1 have id 23 and producer 2 have id 123)
Now I got your issue. for this purpose you need SD Live CCK Field plugin. You should copy Produce Search Type which i made in the tutorial in this new Search Type do the following:
Set "live value" of the producer field with CCK live plugin like i made in below picture.
Make a new Seblod List module and show it on any existing position you would like to show it.
I have made a Magazine site with this plugin but in Joomla 2.5 to show similar articles in a module, at that time this plugin was free but now it is not. As i am in Pakistan and can not use Paypal as it is not supported for our Country so can not buy that plugin.
But I am showing the same what I used in Joomla 2.5. See below:
I was able to follow through for a similar scenario I have regarding Tradeshows which consists of an Event (Product in your example) at a Venue (Producer).
What I was aiming for was to have a List/Search show all trade shows with both the event and venue (like a map and adress etc.). After thorough testing I realized that my problem actually has to do with SD CCK Live Plugin. The symptons was that it always showed the same Venue for all the Events in the list. When I reversed the display order (of the search) it also showed the same Venue for all Events, but another one compared to the previous ordering. I came to the understanding of what was meant by:
Important Note on Usage
SD Live CCK Field does NOT work when there are multiple articles listed on the page, i.e in blog view etc. It works when there is a single full article view, and another search list used (as a module or not, it does not matter).