keeping row selected in multiple portals 
Author Message
 keeping row selected in multiple portals
I have three portals on a form. I wrote a script to go to a field in a
portal, then select last row, then go to a field in the next protal,
etc. It works at first as I step through it (with message pauses) but
when the focus moves off a given portal that portal jumps back to its
first row. How do I get it to stick to the chosen row?

Thanks
Tom 2



Sun, 17 Aug 2003 23:32:01 GMT
 keeping row selected in multiple portals

There's no way around this basic portal behavior. However, you could set
local global fields to the related record IDs of the selected record in each
portal and have a line of fields above each portal showing the selected
record's info via a global field to record ID relationship.

--

Chris Kubica
_______________________________________
Author of FileMaker Pro: The Complete Reference
published by Osborne/McGraw-Hill
www.osborne.com
_______________________________________

Quote:
> I have three portals on a form. I wrote a script to go to a field in a
> portal, then select last row, then go to a field in the next protal,
> etc. It works at first as I step through it (with message pauses) but
> when the focus moves off a given portal that portal jumps back to its
> first row. How do I get it to stick to the chosen row?

> Thanks
> Tom 2



Sun, 17 Aug 2003 23:53:27 GMT
 keeping row selected in multiple portals
For best results, keep a global row counter for each portal, and use
GoTo Portal Row by counter before each and every row access.

-- Margaret Nupponen

Quote:

> I have three portals on a form. I wrote a script to go to a field in a
> portal, then select last row, then go to a field in the next protal,
> etc. It works at first as I step through it (with message pauses) but
> when the focus moves off a given portal that portal jumps back to its
> first row. How do I get it to stick to the chosen row?

> Thanks
> Tom 2



Mon, 18 Aug 2003 01:51:02 GMT
 keeping row selected in multiple portals
Chris,
    Your solution sounded good until I actually tried to implement it
Friday. The problem is, how do you enter into those global fields and get it
transfered to the portal fields without the user having to do something
extra like press a "save" button, which they're not used to needing to do
with FM?

Thanks,
Tom2


Quote:
> There's no way around this basic portal behavior. However, you could set
> local global fields to the related record IDs of the selected record in
each
> portal and have a line of fields above each portal showing the selected
> record's info via a global field to record ID relationship.

> --

> Chris Kubica
> _______________________________________
> Author of FileMaker Pro: The Complete Reference
> published by Osborne/McGraw-Hill
> www.osborne.com
> _______________________________________


> > I have three portals on a form. I wrote a script to go to a field in a
> > portal, then select last row, then go to a field in the next protal,
> > etc. It works at first as I step through it (with message pauses) but
> > when the focus moves off a given portal that portal jumps back to its
> > first row. How do I get it to stick to the chosen row?

> > Thanks
> > Tom 2



Fri, 22 Aug 2003 23:36:06 GMT
 keeping row selected in multiple portals
Maggie,
    What triggers the script which would get the protal in sync with the
global row counter? Does the user have to press some next/previous buttons
or something? I can see that between your suggestion and Chris' this brings
me close to a solution, but only by virtually recreating the portal
manually. In fact I may try forgetting the portal and just create some
fields linked by relationship and keyed by a "row counter" in effect and
controlled by some manually scripted next/previous buttons. It's hard to
believe such a mature product has such quirkiness in such basic functions.


Quote:
> For best results, keep a global row counter for each portal, and use
> GoTo Portal Row by counter before each and every row access.

> -- Margaret Nupponen


> > I have three portals on a form. I wrote a script to go to a field in a
> > portal, then select last row, then go to a field in the next protal,
> > etc. It works at first as I step through it (with message pauses) but
> > when the focus moves off a given portal that portal jumps back to its
> > first row. How do I get it to stick to the chosen row?

> > Thanks
> > Tom 2



Fri, 22 Aug 2003 23:41:18 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Goto related from portal --how do I get the selected portal row

2. question regarding select (multiple rows select into one result row)

3. Grouping multiple rows into 1 row during a select into

4. SELECT multiple rows back as one row with many columns

5. adding multiple rows in portal, using web form?

6. Editing Multiple Portal Rows on the Web?

7. colour select a portal row?

8. portal row select

9. column in multiple rows to multiple columns in one row

10. column in multiple rows to multiple columns in one row

11. PL/SQL: best way to find and remove duplicate rows ( keep 1 row )

12. Select @@IDENTITY returning multiple rows?!


 
Powered by phpBB® Forum Software