Roberta, you have the knowledge, yes... but you just need to implement the training differently.

For example, the answer to your first question would be to set up a hyperlink for each of the letters in the alphabet for your index page, and then use the WILDCARD characters like we learned in ASP 303 for each one. For example, if you want all of the "T" last names, you would say:

SELECT * FROM CustomerT WHERE LastName LIKE 'T%'

That would give you all of the "T" last names. Now just make a page that reads in the letter from the querystring, and set up your index page accordingly.

As far as the second question is concerned, there are two ways to do this. The first method is to use the PAGE property of a recordset which I did NOT show you - honestly because I don't use it. I prefer to do this myself with a counter variable:

When displaying the records, just keep a count of how many you have displayed in your loop (X=X+1) and STOP when you've reached a certain number (50 or 100 per page, for example). Then at the bottom of the page when you have a NEXT button, include the ID of the last item you displayed. Read that value in on the next page, and then start displaying records from there. You should be able to figure this out. If not, let me know and I'll try to include it in the next lesson.