one to many or many to one relationships

[fmp7]

How do I setup a one to many or many to one relationships?

For example, I have inventory table which contains SKU & PRICE and worksheet table has SKU1, SKU2, SKU3, PRICE1, PRICE2, and PRICE3. As I fill in the SKU1, SKU2, and SKU3. I want the price to be looked up and fill in the price1, 2, and 3 fields. I don’t wish to use the repeating field.

I was able to do this on previous version but I am having some trouble with fmp7.

Any input would be appreciated.

 

[fmp7]

Never mind! I found it...
self-joining relationships.

Thank you...