Seeing found set in a portal (self-join) 
Author Message
 Seeing found set in a portal (self-join)
How can a portal be set up so that it displays only the found set instead
of the records related to the matching field?


Sun, 27 May 2001 03:00:00 GMT
 Seeing found set in a portal (self-join)

Quote:

> How can a portal be set up so that it displays only the found set instead
> of the records related to the matching field?

Remember that the relationship drives what displays in a portal, nothing
else. To change the portal contents, you must change the relationship. A
way to do this dynamically is to create a calc field that combines your
usual relating field AND a second TEMP field that is set after a
find..say by inserting a 1. Create the same calc field in the parent DB
containing the portal, and base the relationship of the portal and all
its fields on that.

Then script a find in the child DB to find the records and then do a
calculated REPLACE into the Temp field.  Usually it's wise to clear that
entire Temp field first, of course, or you get spurious results.  Then
your found set will show in the portal.  You can either leave the found
set as is, or clear the Temp field after the viewing.

Note: this is NOT a permanent solution to preserve found sets. The found
set will change every time you refind.

--

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



Sun, 27 May 2001 03:00:00 GMT
 Seeing found set in a portal (self-join)

Quote:

>How can a portal be set up so that it displays only the found set instead
>of the records related to the matching field?

My way of doing this is to make a relationship to the foreign file with
_all_ possible information I can.

I relate two databases, Order form and a funnel database (it sifts
information from order form to a customer database for a complete overlook
of things ordered) called Items like so:

In Items it's
Serial [name &date] (calculation): "Check" & Date & Id

In Order form it's
Serial [name&date] (calculation): Check & Date & Id

Then I display the info from Order form in Items with these two calc fields
as the key. This way, all lines that are checked are displayed and the other
ones are not.
Beware though of arranging the fields correctly in the formula. For example
making the formula: Check & First name & Last name & date would not match
correctly if the result is : "CheckHarveyManfrentonsonEsq.III12.09.1998"
because FM can't match on really long key fields (about 30 characters).

Hope this helps,

NJ



Sun, 27 May 2001 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Searching Portals and displaying found Set in same Portal

2. Filtered self-join portals

3. Highlight row in self-join portal

4. Problem with Portals in Self-Join

5. Self-join and Portals

6. Portal in a self-join

7. FMP 4.0 self-join, portal problem

8. Self Join - How to find previous date

9. Update SET with Self Join returns Msg 8154 table ambiguous

10. Displaying a Found Set Record in a portal?

11. Self join VS equi join

12. Inner Join / Self Joins help!


 
Powered by phpBB® Forum Software