Hi,
we have Accounting Solution in FM11. On each Invoice (Table A) are most of the time more than one Invoiceline (Table B) where we place a Product (Table C).

We edit the calculated Description Field and add a Serial Number of the Product we want to sell.

For Example
After we choosed the Product

BP-01820, PEE:BA-DC-32CH
BrainAmp DC 32-Channel single amplifier

Then We add

BP-01820, PEE:BA-DC-32CH
BrainAmp DC 32-Channel single amplifier
AMP10041223

And now you might guess what we need to search for

We find the Record when we type in the Serial Number from the beginning like:

AMP1004 -> we get back every Order with a Product starting with AMP1004

OK. But. Most of the time we like to start backwards withe last 3 digits.

But if a look for *1223 i get nothing or completly wrong results.

Maybe someone has a idea?

Br
Charley

Interesting problem.

So what's happening is that fmSearchResults sees *1223 and, there being no letters in the search request, only searches the fields you've tagged as integer fields on your Table0X layouts.

So one fix is to add a new integer field to the search Table0X layout for the table in question and point it to this Description field. Give it an object name like "number02" (without the quotes).

You could also create a field that held just the last 4 digits of this serial number, add it as an integer to your search layout (your Table0X layout) and search on that without the *

In both cases, FMSR will search your text fields when you search for AMP10041223 and your number fields when you search for *1223

Thank you.

Adding the Description Field as an Interger Field on my TableXX worked fine.