GetNthRecord as a navigation list [Beta-8]

[Ender]

Description: Here's a demo of a technique to use FM8's new GetNthRecord() function to produce a navigation list showing the previous/current/next records.

It still uses self-join relationships to show the actual data, but the parent keys are generated on the fly using the GetNthRecord() function. This allows users to use the status bar to change records, and the navigation list will still update correctly. Unlike a portal, this technique keeps the navigation list in the order of the found set. Also, the navigation list is only showing records from the found set.

Working Under: 8

Solution Status: Beta

Pre-requisites: FM8

Author(s): Ender

Date: 08/30/05

Credits:

Instructions / Other Info:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Purchase_Orders.fp7.zip