Finding certain records to display in a portal

Hello,

I have a portal that currently shows all related records (as it
should). Sometimes, however, I'd like it to only display certain
records.

Every record in my related file has a field called "active" - this
displays whether the player is active or not (with a "Yes" or "No").

I would like to create a button that - when pressing it - will only
display those players listed as "active" in the portal. I can then
have another button that will reverse this (i.e., do the default -
show all).

What would be the easiest way for me to set up this "find?" -- I can
then throw it in a script, for the button...

I'm using FM 5.5.

Thanks!

Chris

Re: Finding certain records to display in a portal

"Lemur" schreef in bericht
news:1190061161.971838.320700@g4g2000hsf.googlegroups.com...
> Hello,
>
> I have a portal that currently shows all related records (as it
> should). Sometimes, however, I'd like it to only display certain
> records.
>
> Every record in my related file has a field called "active" - this
> displays whether the player is active or not (with a "Yes" or "No").
>
> I would like to create a button that - when pressing it - will only
> display those players listed as "active" in the portal. I can then
> have another button that will reverse this (i.e., do the default -
> show all).
>
> What would be the easiest way for me to set up this "find?" -- I can
> then throw it in a script, for the button...
>
> I'm using FM 5.5.
>
> Thanks!
>
> Chris
>
\
create a global in file A gYesNo
Create a relation between this field and the normal YesNo field of file B
Create a portal for this relation in file A
Create a button in file A, Set gYesNo, If gYesNo="Yes" ; "No"; "Yes" (This
flip/flops the value from yes to no and vice versa)
When the gField is set to YES you will see the records that are marked YES
in the other file.

Keep well, Ursus

Re: Finding certain records to display in a portal

On Sep 17, 5:40 pm, "Ursus" wrote:
> "Lemur" schreef in berichtnews:1190061161.971838.320700@g4g2000hsf.googlegroups .com...
>
> > Hello,
>
> > I have a portal that currently shows all related records (as it
> > should). Sometimes, however, I'd like it to only display certain
> > records.
>
> > Every record in my related file has a field called "active" - this
> > displays whether the player is active or not (with a "Yes" or "No").
>
> > I would like to create a button that - when pressing it - will only
> > display those players listed as "active" in the portal. I can then
> > have another button that will reverse this (i.e., do the default -
> > show all).
>
> > What would be the easiest way for me to set up this "find?" -- I can
> > then throw it in a script, for the button...
>
> > I'm using FM 5.5.
>
> > Thanks!
>
> > Chris
>
> \
> create a global in file A gYesNo
> Create a relation between this field and the normal YesNo field of file B
> Create a portal for this relation in file A
> Create a button in file A, Set gYesNo, If gYesNo="Yes" ; "No"; "Yes" (This
> flip/flops the value from yes to no and vice versa)
> When the gField is set to YES you will see the records that are marked YES
> in the other file.
>
> Keep well, Ursus

Hello,

This did not work. When I changed the portal from the current
relationship to this new relationship I get many MORE records than I
want (and they're all the same). I need to still keep getting the same
records, and just reduce them (basically, instead of it just
displaying related records that match in the 'field for relation,'
they also need to match in the "active" field, as well.

Chris

Re: Finding certain records to display in a portal

On Sep 19, 1:52 pm, Lemur wrote:
> On Sep 17, 5:40 pm, "Ursus" wrote:
>
>
>
> > "Lemur" schreef in berichtnews:1190061161.971838.320700@g4g2000hsf.googlegroups .com...
>
> > > Hello,
>
> > > I have a portal that currently shows all related records (as it
> > > should). Sometimes, however, I'd like it to only display certain
> > > records.
>
> > > Every record in my related file has a field called "active" - this
> > > displays whether the player is active or not (with a "Yes" or "No").
>
> > > I would like to create a button that - when pressing it - will only
> > > display those players listed as "active" in the portal. I can then
> > > have another button that will reverse this (i.e., do the default -
> > > show all).
>
> > > What would be the easiest way for me to set up this "find?" -- I can
> > > then throw it in a script, for the button...
>
> > > I'm using FM 5.5.
>
> > > Thanks!
>
> > > Chris
>
> > \
> > create a global in file A gYesNo
> > Create a relation between this field and the normal YesNo field of file B
> > Create a portal for this relation in file A
> > Create a button in file A, Set gYesNo, If gYesNo="Yes" ; "No"; "Yes" (This
> > flip/flops the value from yes to no and vice versa)
> > When the gField is set to YES you will see the records that are marked YES
> > in the other file.
>
> > Keep well, Ursus
>
> Hello,
>
> This did not work. When I changed the portal from the current
> relationship to this new relationship I get many MORE records than I
> want (and they're all the same). I need to still keep getting the same
> records, and just reduce them (basically, instead of it just
> displaying related records that match in the 'field for relation,'
> they also need to match in the "active" field, as well.
>
> Chris


Nevermind...I figured it out.

Rather than create a global field, I simply added the Active "YES" on
to the end of the search string and set up a duplicate portal and
layout, with a button to flip between the two layouts, as needed. Does
the same thing I needed, effectively.

Thanks!

Chris