Richard,
The Get ( FoundCount ) function is highly context-sensitive, and will
give different results based on where you use it. Just because it
returns 250 in the People file does not mean that the same result is
true in another file. From the point of view of the Members file, the
cross-product relationship to People "finds" all 8000 records. So
it's giving you the "correct" results.
As another example, you could launch a new window of the People file,
do another find, and each window will have two separate results for
Get ( FoundCount ). Both are valid.
To solve your problem, you could try something like the following:
- Define a global number field in People named g_FoundCount
- Create a script in People that does the following step:
Set Field [People::g_FoundCount; Get ( FoundCount )]
- Create a script in your Members file that first performs the new
script in People and then switches to your layout with your message.
Alter the calculation for the text block to refer to the
People::g_FoundCount field, rather than the People::Found calc.
Regards,
Chad
On Jan 3, 2008, at 7:09 PM, Richard Russell wrote:
So here's the "People" file, which has about 8000 records. Of that
number, about 250 will be in next semester's choir. So I tag those
250 to make them easy to find and DO the find. My found count is
thus 250. I have a calculated field, called "Found", defined as
Get ( FoundCount )
and set to produce a numeric result, unstored. In "People" it
displays 250 for every visible record.
Then, over here, I have the "Members" file, into which I want to
import the 250 PersonID codes. The screen I've got set up for my
user has a text block displaying the message "You've found X records
in the 'People' file. If this is the right number, click the
'Import' button below. Otherwise yada yada yada ..."
It doesn't actually SAY "X", of course. In Layout mode, it looks
like this:
People::Found
where "People" is a cross-product (all to all) link from "Members"
to "People".
Here's the hinky part. In Browse mode, it SHOULD say 250, because
that's the number of records I've found. But it doesn't. It says
8000, which is the total record count.
Doing a "Refresh Screen" doesn't help.
Any ideas?
***************
Chad Novotny
Vice President - Technology
The Support Group, Inc.
database design, development and training services
boston - los angeles - new york - san francisco
24 Prime Park Way
Natick, MA 01760
t: 508.653.8400 x217
f: 508.653.2830
[EMAIL PROTECTED]
www.supportgroup.com
