Serial Numbers within Orderlines not found

Support, Tips and Mods for Matt Navarre's SearchResults technique.
PostPosted: Tue May 11, 2010 3:10 am
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

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?

SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed May 12, 2010 2:57 pm
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
John Sindelar
PostPosted: Mon May 17, 2010 12:37 am
Thank you.

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

Return to fmSearchResults

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: