How to add indexes for my customer table?
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
Re: How to add indexes for my customer table?
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.