Find on Field gives Incorrect Result

I have a radio button named Questionaire on layout Dinner from the
Table Dinner. I built a second layout named student that is linked to
the table dinner but only shows the students. When I do a find on the
Student layout for Questionaire I get too may results and it displays
radio buttons that are not marked.

I have been over the relationships, I have walked backwards through
the realtionships. What am I doing wrong!?

Thanks so very much!!!

Re: Find on Field gives Incorrect Result

"Techy Wannabe" schreef in bericht
news:1190825836.443164.234230@50g2000hsm.googlegroups.com...
>I have a radio button named Questionaire on layout Dinner from the
> Table Dinner. I built a second layout named student that is linked to
> the table dinner but only shows the students. When I do a find on the
> Student layout for Questionaire I get too may results and it displays
> radio buttons that are not marked.
>
> I have been over the relationships, I have walked backwards through
> the realtionships. What am I doing wrong!?
>
> Thanks so very much!!!
>

There are are more possible answers to this.

Possinble are: searching on students will return ALL students, maked and
unmarked. Searching on only marked or unmarked will find all subjects which
include students and all others.

second: finding on eggs will deliver eggs, eggs baked, eggs fried etc etc.

So without knowing more of the exact structure and contents of you solution
it is not possible to guess what exactly is happening. And as good practice
you might also post platform and version with all your questions. Answers
may vary according to these.

Keep well, Ursus

Re: Find on Field gives Incorrect Result

On Sep 26, 12:10 pm, "Ursus" wrote:
> "Techy Wannabe" schreef in berichtnews:1190825836.443164.234230@50g2000hsm.googlegroups .com...
>
> >I have a radio button named Questionaire on layout Dinner from the
> > Table Dinner. I built a second layout named student that is linked to
> > the table dinner but only shows the students. When I do a find on the
> > Student layout for Questionaire I get too may results and it displays
> > radio buttons that are not marked.
>
> > I have been over the relationships, I have walked backwards through
> > the realtionships. What am I doing wrong!?
>
> > Thanks so very much!!!
>
> There are are more possible answers to this.
>
> Possinble are: searching on students will return ALL students, maked and
> unmarked. Searching on only marked or unmarked will find all subjects which
> include students and all others.
>
> second: finding on eggs will deliver eggs, eggs baked, eggs fried etc etc.
>
> So without knowing more of the exact structure and contents of you solution
> it is not possible to guess what exactly is happening. And as good practice
> you might also post platform and version with all your questions. Answers
> may vary according to these.
>
> Keep well, Ursus

Hi...yes I agree with your analogy but I am not searching for students
and getting students.

I will try again and please be patient with me because I am a new
user.

FileMaker Pro v. 8.5, FileMaker Server, Windows Op XP Professional.

I linked a radio button from one layout to another. When I perform a
find for questionaire=active radio button and "only active radio
button" I get results that do not make sense. An active radio button
to me means that the center is filled in. I do not get all of the
records in the database but not all of the returns have an active
radio button.

I have constrained the find to just questionaire=active radio button.

I hope I have been more clear.

Thanks.

Re: Find on Field gives Incorrect Result

Techy Wannabe wrote:

> I linked a radio button from one layout to another. When I perform a
> find for questionaire=active radio button and "only active radio
> button" I get results that do not make sense. An active radio button
> to me means that the center is filled in. I do not get all of the
> records in the database but not all of the returns have an active
> radio button.

It could depend on the key fields you are using for your relationship.
Are the fields on both sides of the relationship all stored and indexed
fields?

Or...have you ever opened the database with FM9? This can mess up your
index if you then go back to 8.5. There are other that can corrupt an
index, as well. You can try reindexing your search field by turning
indexing off in that field's storage definition, but make sure the
option is marked to allow it to index when necessary. Perform your
search again and it should reindex.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Professional Solutions, Inc. Los Angeles

FileMaker 8 Certified Developer
Associate Member, FileMaker Solutions Alliance

Re: Find on Field gives Incorrect Result

>
> Hi...yes I agree with your analogy but I am not searching for students
> and getting students.
>
> I will try again and please be patient with me because I am a new
> user.
>
> FileMaker Pro v. 8.5, FileMaker Server, Windows Op XP Professional.
>
> I linked a radio button from one layout to another. When I perform a
> find for questionaire=active radio button and "only active radio
> button" I get results that do not make sense. An active radio button
> to me means that the center is filled in. I do not get all of the
> records in the database but not all of the returns have an active
> radio button.
>
> I have constrained the find to just questionaire=active radio button.
>
> I hope I have been more clear.
>
> Thanks.
>

Without further details I can't work out what is happening. Can you post the
script with all the details (where you are when you start it, how do you
start it, etc) or else reproduce a very accurate step-by-step. Generally a
plain 1 on 1 search should return what you expect. The fact that it doesn't
is suspect. And please remember that a button list is only added onto a
normal textfield to function as on/of switches. The contents of the field
remains a simple text. You might also try to put a version of the same field
alongside, plain without any additions, make it a bit larger so any
extranious lines with return will show. Put a Pause step between evry script
step and run the script, verify that after eacgh step you see what you
expect. You might try to use a step-by-step find (goto find, set field,
perform find) to make more clear what is happening.

Keep well, Ursus

Re: Find on Field gives Incorrect Result

In article <1190825836.443164.234230@50g2000hsm.googlegroups.com>,
Techy Wannabe wrote:

> I have a radio button named Questionaire on layout Dinner from the
> Table Dinner. I built a second layout named student that is linked to
> the table dinner but only shows the students. When I do a find on the
> Student layout for Questionaire I get too may results and it displays
> radio buttons that are not marked.
>
> I have been over the relationships, I have walked backwards through
> the realtionships. What am I doing wrong!?
>
> Thanks so very much!!!

As others have said, it's a little difficult to know what's happening,
but my first guess is that you're performing the find from the wrong
end.

For example, if you have two related tables where each record in Tabel
1 is related to multiple Table 2 records
eg.
TABLE 1 TABLE 2
Fred Flintstone --> No
Yes
No
No

If you perform a Find in Table 1 to find the "Yes" records, then Fred
Flintstones' record will be found, even though the top-most related
record is a "No".

If the layout has only the related field on it you will see the "No"
and think the Find hasn't worked properly. This is because a related
field by itself will only show the top-most related data.

If you instead put a Portal on the layout that contains the related
field, then you will see all the related records, including that single
"Yes" one.

Basically you've asked FileMaker to find Table 1 records that have a
"Yes" in ANY related record.

If you want to find just those with the top-most related record is
"Yes" you will have to create a different Relationship to separate that
related record from the others (eg. perhaps a date stamp).

Or, you can perform the Find in Table 2 and print / display the report
that way, using a relationship back to Table 1 to retrieve the names.


Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)