March 18, 200124 yr I want to use a set of alphabetical buttons (A,B,C. ...) to navigate through a list of contact people. I thought I'd seen an article about a good way to do this, but now I can't find it. Does anyone have any leads or suggestions? Thanks, Keith Silva
March 18, 200124 yr For real speed, I'd use a relationship. Define the right side field as: AlphaIndex (calc, text, indexed) = Left(Trim(LastName), 1) Define the left side field as: gSearch (global, text) Define a relationship called SelfByAlpha with gSearch <--> AlphaIndex The script for each button is of the form: Set Field (gSearch, "A") Go to related record(SelfByAlpha, show only related records) This will be MUCH faster than a find for large sets of records. -bd [This message has been edited by LiveOak (edited March 18, 2001).]
March 19, 200124 yr Author LiveOak: Thanks for the fast and detailed response. I understand the approach you have described and will work on it this week. Thanks again. Regards, Keith Silva
Create an account or sign in to comment