Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.datemas.de!rt.uk.eu.org!aioe.org!.POSTED!not-for-mail
From: Helpful Harry <HelpfulHarry@BusyWorking.com>
Newsgroups: comp.databases.filemaker
Subject: Re: Found record, but field does not have the value displayed in
Date: Thu, 21 Nov 2013 19:34:23 +1300
Organization: Aioe.org NNTP Server
Lines: 22
Message-ID: <211120131934239168%HelpfulHarry@BusyWorking.com>
References: <04e807bf-a4f0-4ab9-88e7-e436fddb6061@googlegroups.com> <84f9627b-59d0-4717-8dd9-3e2f7189c5a7@googlegroups.com>
NNTP-Posting-Host: KzgWuX9B56ro01gk1Z9B/A.user.speranza.aioe.org
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: abuse@aioe.org
User-Agent: Thoth/1.5.4 (Carbon/OS X)
X-Notice: Filtered by postfilter v. 0.8.2
Xref: csiph.com comp.databases.filemaker:1533

In article <84f9627b-59d0-4717-8dd9-3e2f7189c5a7@googlegroups.com>,
Bizouman <bizouman@gmail.com> wrote:
> 
> By the way FM12Av4 Win7, with FMS12
> 
> Guess what.
> 
> I created a new layout from scratch using FM template, adding all the fields.
> 
> Found the one I was looking for... and BINGO, for no reason in that field,
> there it is.. 31/08/2011 .... delete the field, and Voila!! it's not
> returning in the found set.
> 
> Now it's working, but WHY ???

First guess ... especially if the Find is preformed using a Script,
then the original field you were looking at probably wasn't what you
thought it was, e.g. it was the date field or layout was via a
relationship where the record with the date "31/08/2011" didn't meet
the relationship's requirements.

Helpful Harry  :o)