TREBORA Posted February 26, 2008 Share Posted February 26, 2008 Last time I used FM with any authority was in 1999. I have forgotten almost everything, so treat me tenderly please. smiley-wink I have two fields of prices in a 65,000 line database. One is Euros, the other USD$. About 250 possible combinations exist. I wish to give each combination a Price Code, and have this auto-entered into a third field in this DB. In a separate spreadsheet, I have the Price Codes for each combination. How do I go about this? Thanks in advance. Quote Link to comment Share on other sites More sharing options...
aaa Posted February 26, 2008 Share Posted February 26, 2008 Hi, TREBORA! Why not such: Price Code=Eur&"_"&USD May be i dont understand your question? Quote Link to comment Share on other sites More sharing options...
Ender Posted February 26, 2008 Share Posted February 26, 2008 I don't think I understand either. How do two prices (US and Euros) turn into 250 possible combinations?? Quote Link to comment Share on other sites More sharing options...
TREBORA Posted February 27, 2008 Author Share Posted February 27, 2008 Opps! Let me explain. Two fields in a 34 field, 65,000 line database [Master] contain prices, one in Euro, the other in USD. There are about 250 possible combinations [eg Euro 22.00 - USD 24.00]. In a separate database the combination of these 250 two prices have been given a Price Code [eg L1 = Euro 22.00 USD 24.00]. The Master contains the combinations, but NOT the Price Codes. Am I correct in thinking the Lookup function can be invoked to lookup the combinations in the second database and insert its Price Code into the Master? Is there another way to match/insert the correct price code into the appropriate field in the Master? Thanks guys! Quote Link to comment Share on other sites More sharing options...
Ender Posted February 27, 2008 Share Posted February 27, 2008 Are you saying, based on the two prices, you want to lookup a corresponding code from the Price Code table?? Usually, I would think it would be the other way around. If this is what you're looking to do, are we talking about exact matches for each price? If you put in $11 and 15Euro, will there always be a corresponding Price Code with those exact values, or do you need some sort way to lookup the next higher/lower value? Quote Link to comment Share on other sites More sharing options...
TREBORA Posted February 27, 2008 Author Share Posted February 27, 2008 Hey Ender, Thanks for your interest. Usually it would be the other way around, I agree, but the data I have received from a vendor only includes Price coded for about 20 combinations, so I have generated the balance of the 250 and wish to apply them to the Master DB combinations. The Master will have and can expect ony EXACT price combination requests. Quote Link to comment Share on other sites More sharing options...
Ender Posted February 27, 2008 Share Posted February 27, 2008 In that case, try a relationship based on both prices (a multi-criteria relationship). You can then either show the related Price Code directly on the layout, or use a regular field with an auto-enter Lookup, pulling in the related Price Code. Quote Link to comment Share on other sites More sharing options...
TREBORA Posted February 27, 2008 Author Share Posted February 27, 2008 Thanks, will try! Quote Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.