Displaying a Found Set Record in a portal? 
Author Message
 Displaying a Found Set Record in a portal?

Within the same database, I want to display in a portal all the records in
the current found set.

I have created a marker field (InFoundSet) which is filled by a "Yes"
through a script right after a new set of records is found. The script also
replaces previous occurrences with an "" (empty) value.

The Replace step is used in the MarkScript and the UnMarkScript. The
UnMarkScript is run first, therefore, I am sure that only the records in
the current found set are marked with a "Yes".

I have also created a self-join relationship with the InFoundSet match
field.

However, instead of displaying all found records, the portal displays only
the same record, but as many times as there are records in the found set,
and it is not necessarily the same record displayed in the master window.

What is wrong with this approach?

Thanks again for your input.



Tue, 29 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?

Quote:

> Within the same database, I want to display in a portal all the records in
> the current found set.

> I have created a marker field (InFoundSet) which is filled by a "Yes"
> through a script right after a new set of records is found. The script also
> replaces previous occurrences with an "" (empty) value.

> The Replace step is used in the MarkScript and the UnMarkScript. The
> UnMarkScript is run first, therefore, I am sure that only the records in
> the current found set are marked with a "Yes".

> I have also created a self-join relationship with the InFoundSet match
> field.

> However, instead of displaying all found records, the portal displays only
> the same record, but as many times as there are records in the found set,
> and it is not necessarily the same record displayed in the master window.

> What is wrong with this approach?

> Thanks again for your input.

It SHOULD work. Check to see if the fields of the portal are completely
within the first row of the portal on the layout. If the upper left
corner of the fields happens to slop out of the row, you'll get the
first-record-over&over phenomenon.
--

Allen & Allen Semiotics                          Web & Graphic Design
Long Beach CA USA               Filemaker Pro Consulting - Member CSA
562.938.7890  fax 562.938.7891            Custom Solutions & Training


Tue, 29 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?
Gee! The same portal works fine with other types of relationships.
Therefore, the position of individual fiels within the portal is alright.

I am confused. Like you, I know it SHOULD work but it does not. Maybe this
does not work with found sets. Have you ever tried it? Please do just to
confirm that it does indeed work.

Thanks again.



Quote:


> > Within the same database, I want to display in a portal all the records
in
> > the current found set.

> > I have created a marker field (InFoundSet) which is filled by a "Yes"
> > through a script right after a new set of records is found. The script
also
> > replaces previous occurrences with an "" (empty) value.

> > The Replace step is used in the MarkScript and the UnMarkScript. The
> > UnMarkScript is run first, therefore, I am sure that only the records
in
> > the current found set are marked with a "Yes".

> > I have also created a self-join relationship with the InFoundSet match
> > field.

> > However, instead of displaying all found records, the portal displays
only
> > the same record, but as many times as there are records in the found
set,
> > and it is not necessarily the same record displayed in the master
window.

> > What is wrong with this approach?

> > Thanks again for your input.

> It SHOULD work. Check to see if the fields of the portal are completely
> within the first row of the portal on the layout. If the upper left
> corner of the fields happens to slop out of the row, you'll get the
> first-record-over&over phenomenon.
> --

> Allen & Allen Semiotics                          Web & Graphic Design
> Long Beach CA USA               Filemaker Pro Consulting - Member CSA
> 562.938.7890  fax 562.938.7891            Custom Solutions & Training



Tue, 29 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?
I suspect the problem is that the fields in the portal are not set to
match the relationship the portal is based upon.  This is an easy mistake
to make when you have identically named fields in parent / child DBs or
multiple relationships from the parent file to the child.  I created and
sent Michel a Parent / Child set of DBs which show how accomplish his
objective.  Happy to share with others who may be interested - email me.

Chuck Gardner


Quote:

>>Gee! The same portal works fine with other types of relationships.
>>Therefore, the position of individual fiels within the portal is alright.

>>I am confused. Like you, I know it SHOULD work but it does not. Maybe this
>>does not work with found sets. Have you ever tried it? Please do just to
>>confirm that it does indeed work.

>>Thanks again.




>>> > Within the same database, I want to display in a portal all the records
>>in
>>> > the current found set.

>>> > I have created a marker field (InFoundSet) which is filled by a "Yes"
>>> > through a script right after a new set of records is found. The script
>>also
>>> > replaces previous occurrences with an "" (empty) value.

>>> > The Replace step is used in the MarkScript and the UnMarkScript. The
>>> > UnMarkScript is run first, therefore, I am sure that only the records
>>in
>>> > the current found set are marked with a "Yes".

>>> > I have also created a self-join relationship with the InFoundSet match
>>> > field.

>>> > However, instead of displaying all found records, the portal displays
>>only
>>> > the same record, but as many times as there are records in the found
>>set,
>>> > and it is not necessarily the same record displayed in the master
>>window.

>>> > What is wrong with this approach?

>>> > Thanks again for your input.

>>> It SHOULD work. Check to see if the fields of the portal are completely
>>> within the first row of the portal on the layout. If the upper left
>>> corner of the fields happens to slop out of the row, you'll get the
>>> first-record-over&over phenomenon.
>>> --

>>> Allen & Allen Semiotics                          Web & Graphic Design
>>> Long Beach CA USA               Filemaker Pro Consulting - Member CSA
>>> 562.938.7890  fax 562.938.7891            Custom Solutions & Training

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
cgardner-at-nova.org * http://super.nova.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-


Wed, 30 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?
Michel,

I know it works because I've done this many times.

Maybe you should check the following:

1) Which fields are placed in the portal? I think you should place the
related fields in there

2) What about the 'refresh window' option? (go to the same layout and
chack this option in your scripts Does that make any difference? I
believe it should not, but it's worth trying it.

3) check your relationships. There may be a wrong relationship between
two fields

4) Do you have the correct portal displayed in your layout? Placing
fields belonging to portal 1 on portal 2 may cause this kind of
problems.

Peter

On Fri, 11 Dec 1998 12:03:34 GMT, "Michel Thibodeau"

Quote:

>Within the same database, I want to display in a portal all the records in
>the current found set.

>I have created a marker field (InFoundSet) which is filled by a "Yes"
>through a script right after a new set of records is found. The script also
>replaces previous occurrences with an "" (empty) value.

>The Replace step is used in the MarkScript and the UnMarkScript. The
>UnMarkScript is run first, therefore, I am sure that only the records in
>the current found set are marked with a "Yes".

>I have also created a self-join relationship with the InFoundSet match
>field.

>However, instead of displaying all found records, the portal displays only
>the same record, but as many times as there are records in the found set,
>and it is not necessarily the same record displayed in the master window.

>What is wrong with this approach?

>Thanks again for your input.



Wed, 30 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?
Thanks to you all. Everything works fine now. My problem was that the
fields in the portal belonged to a previous relationship. I had simply
changed the portal relationship without redefining its field to the new
relationship.

Thanks again a million times.

However, to display the current found set within the database being
searched (records found are from the Parent file [self-join relationship]),
it is only required to have a marker field that marks all records in the
found set each time a new set is created (deleting previous markers of
course beforehand). No need to use a global field. Such a field may however
be required if the Parent file is different than the Child file.



Quote:
> I suspect the problem is that the fields in the portal are not set to
> match the relationship the portal is based upon.  This is an easy mistake
> to make when you have identically named fields in parent / child DBs or
> multiple relationships from the parent file to the child.  I created and
> sent Michel a Parent / Child set of DBs which show how accomplish his
> objective.  Happy to share with others who may be interested - email me.

> Chuck Gardner



> >>Gee! The same portal works fine with other types of relationships.
> >>Therefore, the position of individual fiels within the portal is
alright.

> >>I am confused. Like you, I know it SHOULD work but it does not. Maybe
this
> >>does not work with found sets. Have you ever tried it? Please do just
to
> >>confirm that it does indeed work.

> >>Thanks again.




> >>> > Within the same database, I want to display in a portal all the
records
> >>in
> >>> > the current found set.

> >>> > I have created a marker field (InFoundSet) which is filled by a
"Yes"
> >>> > through a script right after a new set of records is found. The
script
> >>also
> >>> > replaces previous occurrences with an "" (empty) value.

> >>> > The Replace step is used in the MarkScript and the UnMarkScript.
The
> >>> > UnMarkScript is run first, therefore, I am sure that only the
records
> >>in
> >>> > the current found set are marked with a "Yes".

> >>> > I have also created a self-join relationship with the InFoundSet
match
> >>> > field.

> >>> > However, instead of displaying all found records, the portal
displays
> >>only
> >>> > the same record, but as many times as there are records in the
found
> >>set,
> >>> > and it is not necessarily the same record displayed in the master
> >>window.

> >>> > What is wrong with this approach?

> >>> > Thanks again for your input.

> >>> It SHOULD work. Check to see if the fields of the portal are
completely
> >>> within the first row of the portal on the layout. If the upper left
> >>> corner of the fields happens to slop out of the row, you'll get the
> >>> first-record-over&over phenomenon.
> >>> --

> >>> Allen & Allen Semiotics                          Web & Graphic Design
> >>> Long Beach CA USA               Filemaker Pro Consulting - Member CSA
> >>> 562.938.7890  fax 562.938.7891            Custom Solutions & Training

> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> cgardner-at-nova.org * http://super.nova.org
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-



Wed, 30 May 2001 03:00:00 GMT
 Displaying a Found Set Record in a portal?
Michel,

You probably just forgot to display related fields in the portal.
Use "relation::fieldname" and not "fieldname". And make sure "relation" is
actually the relation you are showing in the portal. If you display
"relation::fieldname" but the portal is set up for "relation2" you get your
repeating field phenomenon as well.

Peter



Wed, 30 May 2001 03:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. Searching Portals and displaying found Set in same Portal

2. How do I display number of records in found set

3. Display of Number of Records in Found Set

4. FILTER PORTAL RECORDS - DISABLE ADDING NEW RECORDS IN A PORTAL

5. Portal display related records

6. [WinME] [Portal displaying related records]

7. Q: how to display total number of related records in a portal

8. Help: Controlling portal record display order in FMP v3

9. Displaying Portal Records in sorted order

10. Displaying records in portal

11. max records displayed in portal

12. Displaying a portal based on a portal


 
Powered by phpBB® Forum Software