Amend a multiple field index

Cronk

Registered User.
Local time
Today, 13:28
Joined
Jul 4, 2013
Messages
2,799
I had need to add an additional field to an existing multiple field index with 2 fields. This index was not at the end of the index list so I wanted to insert a row. I could see no way to do this and it was faster to delete the existing index and then create it again with the 3 fields.

This is the first time I've had this need since using Access going back to version 2.

Just out of curiosity, has anyone else had this need and found a way to insert a line?
 
Right click and Insert Rows (A2010)
 
A2007 at this site and right click works but don't know why I didn't try it. Live and learn.
 

Users who are viewing this thread

Back
Top Bottom