MIN value based on common ID number

[kingchad5]

I am looking to create a calculated column that returns the quote number that has the lowest price for each Opportinity.  

I have 2 tables.  

-  Table 1 = Opportunities

         -  Unique Opportunity ID

-  Table 2 = Quotes

         -  Each quote has a relationship to the Opportunity ID

Min Quote ID would be the calulated column.

Example Data

Table 1			Table 2
Opportunity ID	Min Quote ID		Quote ID	Quote Price	Opportunity ID
1	ABC123		ABC123	100	1
2	ABC126		ABC124	200	1
3	ABC131		ABC125	300	1
4	ABC132		ABC126	50	2
5	ABC135		ABC127	200	2
			ABC128	600	2
			ABC129	600	3
			ABC130	500	3
			ABC131	200	3
			ABC132	800	4
			ABC133	900	4
			ABC134	950	4
			ABC135	100	5
			ABC136	200	5
			ABC137	300	5

Please let me if you have any ideas.

Thanks,

Chad