[pilot-db-list] Creating an index of items with a specific category in a field?

[Shaun Q <sh...@qu...>]

Hi there guys!

I'm trying to get a price book up for work here... I'm working with a 
large (2 Meg) CSV file which I imported and successfully can use on DB on 
my palm...

The problem I'm runing into is that I need to be able to select a 
"category" and that will bring me to the first record in that category. 
Each category is contained within a separate cell for each record (a 
separate cell on each row).

First, I sorted by Category.

Then, I created a seperate database called "Index to..." and copied the 
list of unique categories into it.

Then I set the category column in the main file to "linked" and the 
category column in the index file to "link" with a link to the main file.

I sync with my palm, click on the category I want within the index and it 
says it can't find the item.  Even when I try to reopen the file with the 
DB-Editor windows app, it says it "The file this database is linked to
couldn't be found".

First of all, am I going about this an appropriate way to make it work 
this way?

Second, why can't I link these files?  Do I just misunderstand how the 
linking stuff works?

Thanks!
Shaun