Need help with data model

[#1]

Hi guys, I need some major help so any advice would be greatly appreciated.

I have two tables: Orders & Cost. The orders table has a specified number of orders for a product from a specific source to a  specific destination. The cost table has a 5 different options of possible sources for a specific location. 

What I need to be able to do: I want a table or chart that shows me the product, source, destination with the three cheapest sources with their associated costs.... without actually showing each "options" from the cost table...

Any ideas?

[MK_QSL]

Can you provide sample data?

[timsaddler]

Hello

As this is quite complex, some example data would be a big help in determining suggestions for an answer?

[#4]

Please see attachment. It is sample data and it shows how I would like it to look like.

[#5]

Any ideas?

[#6]

Hey,

Please see file attached.

Regards

R

[#7]

The problem is that I have over 100's of products..........so that would make this a little difficult

[Clever_Anjos]

Check if fits your needs