Lookup - phone number

[simoncpage]

I have attached a csv file of local area codes for the UK. The numbers vary in size from:

01130 - Leeds to 0113288 - Hareworod

What I want to do is once a phone number is typed in to the database say for instance 0113 027381 it will return Leeds and like wise if some one was to type in 0113 288 300 - it would return Harewood.

Obviously since I allow spaces in the phone field I would need to do a comparison with Trim(PhoneNumber).

What I have done is to set up a calc field that contains the split of the entered phone numbers to 4 to 6 places (taking out the 0 and from the left). And then create a relationship with this and the table of codes.

Attached is my first attempt...but anyone have any better ideas? comments?

Thanks

atmp1.zip