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

    Lookup a value from a range of values

    piloo

      Title

      Lookup a value from a range of values

      Post

      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

       

      69956104:69956111:BERMUDA

      ....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?

       

      Thanks