Craig:
I need to use the grid to display up to 300,000 records. Some clients will be using it to display only a few hundred records, but I don't want to create separate systems. Also, I created text boxes to limit or SEEK the appropriate records in the grid. As soon as the user enters something into the textbox, the pointer SEEKs the appropriate record. If the user enters something into both of the textboxes (eg., partial first name and partial last name), it filters to the matching records. A SQL SELECT will probably take too long to get the records.
I am hoping that there is some obscure way of either: 1) determining the row numbers of non-active rows, or 2) finding out a record's position in an indexed table (in other words, if you had a table of every Major League Baseball player in history, and indexed it by Name, is there a variable that would show that Hank Aaron is the first record in the index?).
Any ideas?

Jerry