I have a grid that is fed by a potentially large table (up to 300,000 records and fairly wide). Depending on which radio button is clicked, the table indexes in different ways (last name, account number, first name, date of birth, etc.). How do I get the rows to alternate colors (odd rows color A, even rows color B)? Setting them by record number doesn't work because the table can be indexed several ways. Also, sometimes the grid will contain only some of the records (for example, records of people with certain initials). Anything that involves scanning the records is too slow. Any ideas?

Jerry