Creative Solution?

[innodat]

It seems I'm hitting a FileMaker limitation - or not?

I have a database to help artists keep track of their artwork. There's an artwork ID field, which is a text field, because every artist has his/her own way of numbering artwork. A typical ID could be

JQ.78.DRW.0803.15

If I search for part of this number, it works fine for any letters (like JQ, or DRW) and it promptly finds the record. If I search for 15 though, no records are found.

Is there a way to make this possible? Search for numeric values in a text field? If I search for the entire ID, it also finds the record...

Thank you for any tips!

[Lee Smith]

Try using the == with 15 and see if that works. i.e. ==15

Lee

[comment]

The default Filemaker search is for "words that start with ...". There is no word that starts with "15" in "JQ.78.DRW.0803.15", because "0803.15" is a single word. This is the reason your search fails - it would fail the same way if you were searching for "ohn", hoping to find "John".

Try searching for "*15" (without the quotes).

[innodat]

Comment, you're great - it totally works!

Thank you.