Show linked fields from another table

Hello Community

I am new here. So first, hello to all
I have a problem. I hope somebody can help me.

I have a product-table. Just a standard default table with an additional field called "name".

Then I have a table called "price". The idea is that the same product have different prices at different shops.
So in the price-table I have a "foreign-key" field to link the price to a product.
So far so good.

So when I watch the product detail form in the frontend. I also want to show all prices which are linked to that product.
This should be a kind of price comparison.

Thank you for your help
Franz

It would be nice if you guys started posting some solutions in the forum

Your decision to not do that is really frustrating and really lowers the overall experience and quality of what could be an amazing product.

Create a forum that only premium people have access to if need be.

But hiding and piece mealing solutions to users is a wrong strategy.