Hello Edward,

Here is a ZIP contianing a GV workspace and an Excel spreadsheet to show you how this works. Here's what you need to know:
  • There are two Views in the workspace, one showing IN history detail lines that contain a Category, and a simple "DUMP" of the IC Category file. The history detail lines have a formula that displays a category description using the GETNAMEDITEM() function and selects only those lines that actually contain a category code.
  • You need to create a file of the form of CatList.GVNames. An easy way to do this is to ExcelDirect the Category View, Copy the third column (Headed "[NamedItems]") and paste it into a text file with a GVNames extension. Load this file into your GridView workspace using Edit | Named Items (F3). (Its name can be specified on the command line so the user does not have to remember to do this using the "/N" parameter).
  • Maintain as necessary.

Hopefully you can figure this out from the building blocks provided here.


Attachments
NameListDemo.zip (73 downloads)



Edited by Andrew Bates (08/19/10 02:43 PM)
Edit Reason: Improved Workspace
_________________________
Andrew Bates