How to add indexes for my customer table?

[tony007]

Hi guys. I got unbounded form that I want to add searching functionality by utilizing indexes. I would like to know how to add indexes for my customer table so that I can use it for searching records. I be happy if some one help with make indexes. Thanks


http://i5.photobucket.com/albums/y18...abledesign.jpg


==> pic of my customer table in design view

[RobDog888]

You already have your customerno filed set with a primary key field and indexed with no dups.
The only other option you could do is to make it a autonumber field instead of a numeric field. Then all your numbers will be autogenerated, etc.