a silly question

[amer]

I have a form (frmCustomer) with following controls on it:

- Data (datCustomer)
Database Name : dbMaster
Record Source : tblCustomer
- MSFlexGrid (flxCustomer)

There are two index associated with tblCustomer
- CustNo (Primary)
- CustName

By default data is appearing in MSFlexGrid with primary index whereas i like to show it on other index (CustName).

Can some body help me and tell me HOW ???

[Bill Crawley]

Hi,

Instead of worrying about using the index. On the grid there is a sort property which you can use against a column. It's very efficient and easy to use.

[amer]

Hi Crawley,

using sort wont slow down the process ???

[JHausmann]

Depends on the number of records, size of recordset, memory available....