|
|
Portal with Found Set
How Can I make a simple portal where in each row there is one of the
fields of each record in the currently found set? (like show the names
of contacts that are in the found set)?
I want the thing to reflect the actual found set when it changes.
Thanks in advance
David Averbach
|
|
0
|
|
|
|
Reply
|
averbach (17)
|
5/5/2006 10:59:50 PM |
|
Not quite clear what you are trying,
When you have only one table (one file previous to FMP7) you don't need a
relation or a portal. Just switch to kiosk view / view as table.
Otherwise you will just see realted info to the current record. You simply
just can NOT see related info on many records. Which means you have a record
active, this has a unique ID (hopefully) that you have used to create a
relation. Since this ID is unique you will only see related info on this
record. And so this is on the B side of your relation the current-related
set.
If this is not what you need please try to refrase, stating version and
platform.
--
Keep well,
Ursus
"davey" <averbach@mac.com> schreef in bericht
news:1146869990.340898.270490@g10g2000cwb.googlegroups.com...
> How Can I make a simple portal where in each row there is one of the
> fields of each record in the currently found set? (like show the names
> of contacts that are in the found set)?
>
> I want the thing to reflect the actual found set when it changes.
>
> Thanks in advance
>
> David Averbach
>
|
|
0
|
|
|
|
Reply
|
ursus.kirk1 (595)
|
5/6/2006 7:34:02 PM
|
|
In article <445cfa24$0$442$dbd43001@news.wanadoo.nl>, "Ursus"
<ursus.kirk@wanadoo.nl> wrote:
> "davey" <averbach@mac.com> schreef in bericht
> news:1146869990.340898.270490@g10g2000cwb.googlegroups.com...
> >
> > How Can I make a simple portal where in each row there is one of the
> > fields of each record in the currently found set? (like show the names
> > of contacts that are in the found set)?
> >
> > I want the thing to reflect the actual found set when it changes.
>
> Not quite clear what you are trying,
>
> When you have only one table (one file previous to FMP7) you don't need a
> relation or a portal. Just switch to kiosk view / view as table.
I'd go with View As List as well.
You could get a Portal of the Found Set records, but it would require
lots of looped scripting to keep changing Key Data / Link field values
and so would be quite slow on large numbers of records. It also
couldn't work through FileMaker's own Find (Apple-F / Ctrl-F) function,
so you'd need you're own Find button for users to click on and/or a
Find script in the Scripts menu.
> Otherwise you will just see realted info to the current record. You simply
> just can NOT see related info on many records. Which means you have a record
> active, this has a unique ID (hopefully) that you have used to create a
> relation. Since this ID is unique you will only see related info on this
> record. And so this is on the B side of your relation the current-related
> set.
Not quite true. You can put a Global field on the Parent side of a
relationship and then the related records using that relationship don't
necessarily have any connection to any of the current record's data at
all (although they might do). :o)
ie.
Global Field <----> Link FIeld
Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
|
|
0
|
|
|
|
Reply
|
helpful_harry (1511)
|
5/7/2006 2:49:33 AM
|
|
> > Otherwise you will just see realted info to the current record. You
> > simply
> > just can NOT see related info on many records. Which means you have a
> > record
> > active, this has a unique ID (hopefully) that you have used to create a
> > relation. Since this ID is unique you will only see related info on this
> > record. And so this is on the B side of your relation the
> > current-related
> > set.
>
> Not quite true. You can put a Global field on the Parent side of a
> relationship and then the related records using that relationship don't
> necessarily have any connection to any of the current record's data at
> all (although they might do). :o)
> ie.
> Global Field <----> Link Field
Sure thing Harry, I just gathered the original sender was not quite into
relations and portals on any level and simplified a bit too much.
Ursus
|
|
0
|
|
|
|
Reply
|
ursus.kirk1 (595)
|
5/7/2006 9:24:46 AM
|
|
See the link to a sample database that I prepared for browsing a list of
records at
http://users.tpg.com.au/aoaug/mac_osx.html#filemaker
"My example Filemaker database that simulates the Open Access browse
window."
This displays a list of records in the main window and details of the
current record in the footer. It may be what you had in mind. You can
change to FIND mode and enter criteria in the fields in the footer to
generate a found set. The corresponding records are displayed in the list.
Michael Paine
davey wrote:
> How Can I make a simple portal where in each row there is one of the
> fields of each record in the currently found set? (like show the names
> of contacts that are in the found set)?
>
> I want the thing to reflect the actual found set when it changes.
>
> Thanks in advance
>
> David Averbach
>
|
|
0
|
|
|
|
Reply
|
mpaine (21)
|
5/11/2006 10:51:17 PM
|
|
|
4 Replies
239 Views
(page loaded in 0.09 seconds)
Similiar Articles: Limiting Portal Records - comp.databases.filemakerI have a portal layout on a page. I only want to show the 6 records in the found set of a "find" in the portal. It is showig me all of the reocrds i... Send mail script step - Sending mail to multiple addresses - comp ...If I use "Use the > current record" flag the mail is sent only to the first student in the > portal. Are you familiar with what a found set is? finding in a portal? - comp.databases.filemakerLimiting Portal Records - comp.databases.filemaker I have a portal layout on a page. I only want to show the 6 records in the found set of a "find" in the portal. Filemaker 7, portals & set field - comp.databases.filemaker ...Go to Field [Select/Perform, "FieldName"] Go to Portal Row [Select, Last] Set field ... Creating New Record in a Portal; Multiple Portals - FileMaker I know you can ... Detecting last record in a found set in a script step? - comp ...Detecting last record in a found set in a script step? - comp ... Export Records ... Script Step "Goto Portal Row" broken? - comp ... How best to detect duplicate ... Printing/Sliding Issues with Portals - comp.databases.filemaker ...In addition, sometimes there'll be a big gap between the bottom portal -- Terms ... in the real database) script: delete all records in the utility table get found set ... Check Box in a Portal - comp.databases.filemakerAttach a script to the checkbox, Set Field(ChildIdSelected = Child::Id). I sometimes find I need to add an ... A portal is set up in the > participant file that displays ... duplicating record with children - comp.databases.filemaker ...When I duplicate a record, is it automatically added to the found set? Is it added ... the parent window, and you'll see the new child records appear in the portal. New Record script step and related tables - comp.databases ...You pass the a portal row entity ID to a global in Admin table, your script must ... The Go To Related Record Script Step Does Not Update The Related Table's Found Set If ... Calculated Find - comp.databases.filemakerThat will show you matching airports in a portal, but two dimensional SmartRanges ... goal will be to then calculate the distance between the > resulatant found set and ... NightWing Enterprises - Portal Found Set Demo for FileMaker ProNightWing Enterprises - Multimedia software development - Art and Imagination! The Orange Box - PortalPortalâ„¢ is a new single player game from Valve. Set in the mysterious Aperture Science Laboratories, Portal has been called one of the most innovative new games on ... 7/30/2012 5:38:08 PM
|
|
|
|
|
|
|
|
|