Match three different critera - one field entry?

[gillian]

Hi

I am looking for a good way to handle a drop down list that would be required to match on three different criteria. It is a list to enter an airport and this can be matched by either a three letter IATA code, a four letter IACO, or the place name itself. Currently I am working in version 9 and while I think I could trigger these entries to complete a join table (from the Airport table) on field exit in version 10, I am struggling to think of an uncomplicated method for version 9.

The result I am after is just as the BA.com website, any thoughts would be greatly appreciated.

[comment]

Try defining a calculation field = IATA code &¶& IACO &¶& place name, and basing the value list (and the relationship) on that. This assumes there are no duplicates within the entire group.

[gillian]

I have tried to concatenate, but what I want to do is show the drop down from part of that entry, I have a feeling that this simply may not be possible i.e. Type in SEN or Southend and match to the airfield name "Southend, SEN, EGMC"

This is how it works on the BA.com website.

[gillian]

That's so simple - thank you I didn't read this properly the first time!

Made my day!