We have a table of jobs that I like indexed on the Job ID which is chronological. The secretaries like it indexed alphabetically on the contractor name. How can I make the table automatically index on Job ID each time it is opened?
Novice
Windows 7 64bit 
Access 2007
We have a table of jobs that I like indexed on the Job ID which is chronological. The secretaries like it indexed alphabetically on the contractor name. How can I make the table automatically index on Job ID each time it is opened?
Moderator
Windows 8 Access 2010 32bit
Why not index both fields? That is the benefit of electronic records over paper records.
You just open the table in design view. Select the field(s) involved and choose the indexed property.
You do not need to reindex each time. That will be handled by the database software.
This video by Richard Rost may be helpful.
Good luck.
'id' is not an index in this table
Posting Permissions
Reply With Quote