next record...

[ron G]

I am using FM 12 v 3  (even if v3 is buggy)

 

I have a main layout based on Members:

 

 

On the left is another Members TOC called Members Portal

 

Everything works great.... except that when I press the right (or left) 'next record' arrows, FM goes to the next Record ID and not to the next Member's Name.

 

Here is the  script I am using:  (pretty simple)

 

 

Question:  "How can I, regardless of recordID, advance to the next 'Member Name' and not next RecordID?

 

I am almost embarassed by what should be a pretty simple and common situation... but I am stumped.  Can someone give me a 'kick start'?

 

Thanks

[comment]

Go to Record [ Next ] goes to the next record of the found set, according to the current sort order. You need to sort your records by Members Name.

 

BTW, committing a record immediately after loading it does nothing.

[bruceR]

Also recognize that the found set may have nothing at all to do with the portal contents.

 

So you need to define what you actually want to do.

 

Do you really want to go to the next record?

 

Or do you want to navigate over the rows of the portal?

[ron G]

Go to Record [ Next ] goes to the next record of the found set, according to the current sort order. You need to sort your records by Members Name.

 

BTW, committing a record immediately after loading it does nothing.

 

The 'shown' portal records are the result of a portal filter.  But, the portal is filtered on LastMiddleFirstName.  As you can see in the following picture, Davis' record is record 1 of 54  but his name is not the first record.

 

So, I added to my startup script a sort by LastMiddleFirst name and that seemed to do it.  Thanks for the thought....

 

[bruceR]

No, that really isn't an answer to the question.

 

The portal and the found set do not necessarily have any relation to each other.

 

For instance Davis might not be an active member; therefore he doesn't show up in the portal at all when Active members are selected.

[comment]

So, I added to my startup script a sort by LastMiddleFirst name and that seemed to do it. 

 

Bruce has a point in that you should make your found set match the set shown in the portal. IOW, perform a find (or show all records) before sorting the records.