Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

How do I get a "lookup" to only read part of an entry?!

How do I get a "lookup" to only read part of an entry?!

How do I get a "lookup" to only read part of an entry?!


I'm pretty new at filemaker (i've done alot of tutorials, but none seem to answer my question...).

So! At the moment I've got realtionship set up with postcodes (and lookups set up - so when the postcode's typed in, the town/city etc are autofilled etc. etc.) This all works fine.

I'm in england, so the postcodes are a bit funny over here. The first half of the postcode tells you the town and area (which is what my linked database contains at the moment) eg; N1 or SE15 etc.

However, there is also a second half which tells you where the address is really specifically (this info is NOT in my linked database).

So a full postcode might look like W1X 1LG

So basically what I want is when I type a postcode into the field lokup will just look at the first section of data, rather than the whole thing. The only problem again with this this though, is that postcodes aren't always uniform.

But they do always start with a letter (or 2) follwed one number (or 2). Any information after this is irrelevant.

I know I'm rambling now, I'm sorry, but I just want to try and make this make sense.

I;d like the lookup to be able to distinguish the difference between letters and numbers. For example if the postcode is N10, it realises there's only one letter, and will go on to recognise the numbers.
Likewise, say the psotcode is EH1X - it will recognise the fist two letters, then go on to the number - then realise there's only one number and stop.

I hope this makes some kind of sense... I apologise if it doesn't.
If anyone could help on this matter it would be HUGELY appreciated!!


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close