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.

Thank you very much pspafford.

Hello..... I'm new to filemaker pro. Using it for about 2 weeks now. just upgraded to FMP 5.5. I need to auto-serial a PO number Field. The Field have to look like XX##/YY/ZZ where XX = Cust Ref (Related by Custmer Name in Contacts File) ## = Year in 01,02,03 format YY = Supplier Ref (Related by Supplier Name in Contacts File) ZZ = Auto generated no. (+1) I can actually do this using 4 different fields instead of 1. But I believe there is a calca or Formula of some sort to achieve the same result. Pls Help me Thank you very Much