Next Record Question

[SuperG]

I have a table lets call it clientlist.db with a unique primary key and client information after that.

ClientID +
ClientFName A
ClientLName A
ClientAddress A
ClientCity A

When I make a next record button it goes to the next record by my primary key. However I would like to have a next button go to the next client in the city of the current client.

How could I do that?

Any help you can give would be great.

Glenn

 

[footpad]

Glenn,

You need to create a secondary index containing the appropriate fields, either City, (most likely) PostalCode, if not both.

Next, make that the active index by:

1. Opening the form in Design mode.
2. Choosing Format | Filter.
3. Selecting your secondary index from the Order By list.
4. Choosing OK and saving the results.

You can also using this to provide alternate sort orders for details tables, provided the first fields in the secondary index are the linking fields to the master table.

Hope this helps...

-- Lance