3 fields from 3 files to get 1 result

[auguzt]

i hope this is not a "Dumb" Question.

I have 3 files Contact, Pricelist and PO

In contact I have a fields name, ref, address, etc

In Pricelist I have

Product Name = Text

PartNo = Num

ACustUSD = Num (price)

ACustSGD = Num (price)

BCustUSD = Num (price)

BCustSGD = Num (price)

In PO, i have

Currency = value list "USD","SGD"

CustomerName = Name in Contact

PartNo = PartNo in Pricelist

Value = Num

here is the question.

I will choose the Currency. eg. USD

Follow By the CustomerName. eg. CustA

Then The PartNo. Eg. Gear

I need to show the price of the product for that customer in that currency.

Value = ACustUSD in pricelist

How do i go about it???

Thank you for your help.

[Cat8]

Try making the field that you enter the currency type into a calc field that looks for a patterncount in itself. So if you put USD into it, it would display the USD price in the field. If you did multiple patterncounts in the calculation, then you could check all of the price list fields for the right amount to display.