2 Replies Latest reply on Apr 12, 2010 4:09 PM by piloo

    Lookup a value from a range of values



      Lookup a value from a range of values


      I have an IP number for which I require the corresponding Country. I have a lookup table of IP(number) ranges corresponding to the allocated country in one table. That is 3 fields; Number from:Number to:country. For example:



      50331648:69956103:UNITED STATES



      ....and so on for 105208 records (number ranges).


      If , for example I wish to find the Country corresponding to 50331649 the query should tell me it is UNITED STATES. 69955023 would be BERMUDA.


      Prior to FM7 there is a documented way to do a lookup which has since changed and now lookups require a relationship. I last did any serious work in FM6 all those years ago and now with post FM7 I'm completely lost!


      Can anyone shed light on how to go about this?