recent record list

[tom robinson]

I'm stumped as to how to implement a recent record list. I have created a global field that gets updated every time a navigation button is clicked / first in last out stack buffered by a pattern-count check to prevent duplicates.

The global field cant be indexed so a valuelist doesn't work ? how can I build a pulldown list for quick access of the last 10 records accessed ? [email protected]

[Razumovsky]

Cool idea,

if your global stores a unique identifier for the records seperated by carrige returns, you could treat this as a multikey.

set selfjoinMulti relationship from the global: g_RecentRecords::UniqueID

and format popup list to display values from related fields selfjoinMulti::RecordName

-Raz

[Vaughan]

Or, if it's single user, create a database with one record and enter the data into a text field there. Create the value list based on this text field.

This solution won't work in multi-user situations.