Google "search date range filemaker"
Link #7 The Secret Life of Find Mode: Dates and Times
Link #11 Date Range Searching Made Easy 12/15/1997
I would guess that thisis the issue:
If you enter find mode and specify criteria in a field from a related table instead of a field from the layout's table occurrence, you are telling FileMaker to "Find all records in the layout's table occurrence that have at least one related record matching the specified criteria." Once the find is performed and the window returns to Browse mode, your layout functions as it was designed to do and the data from the related table may not appear to match the specified criteria as it may show data from a different related record than the one that matched your find criteria.
See this link to learn more:
OK, Phil - good explanation and I've bookmarked that link. It's clear I too failed to understand the impact of doing a "related table" search. To the beginner (me) - if I see it on a layout, I can search for it. Not exactly true; and now I know better.
I then need to create a new field in the "Main" TO, that points to and gets its value from "Details" (I'm using your scenario here).
Have I got that right?
It depends on the results that you want. More likely, you need to perform your search on a layout based on the related table instead of the main table.
Let's say that your relationship looks like this:
Main-----<Details (----< means one to many )
You want to find all detail records where Main::Name = "Apple" and Details::Date has today's date. If you set up a layout based on details, you can Put Main::Name on it as well as Details Date. Perform your find here (either manually or scripted) and you'll get all Detail records that meet this criteria. The trick is to perform such a find from the "context" of the "many" side of your relationship to keep from seeing data from records that don't match your specified criteria.