Portal. From bottom to top?

[Arthurb]

Trying to create a ledger card metephor. Transactions in the portal are posted starting at the top and moving down organized by date (most recent at bottom and oldest at top).

Would like to display to default at the bottom of the portal and show the last "n" records (The most recent) from the bottom of the portal up. Is there a way to do this conveniently.

I know you can do this by setting bits on/off in the child records to allow only those records to show that are most recent. But, this cuts off the ability to scroll through all records.

Any ideas?

[BobWeaver]

If you have a script that brings you to the particular layout or record, add the following step:

Go to Portal Row[Last]

Otherwise, you can add a button to do this.

[This message has been edited by BobWeaver (edited February 05, 2001).]

[Arthurb]

Thanks for the idea.

Can this be done w/two portals at the same time. I believe this approach can be used for one at a time, but not two or more.

Comments?

[BobWeaver]

Yes, but the trick is to go to the correct portal before going to the last record in it. To do this, use the "Go to Field" step picking a field that appears in the portal you want. Then, "Go to Portal Row[Last]". Then "Go to Field" picking a field in the other portal, and then another "Go to Portal Row[Last]".

[Vaughan]

I think the problem is that once you "click out" of the portal it scrolls back up to the top. If there are two portals on the page then only one can be scrolled down to the last.

I think a solution is to work out how to do with just one portal.

[BobWeaver]

Oops, that's right. I don't think I ever noticed that before.