On Tue, 30 Mar 2010 15:54:02 -0700, forest8
wrote:

Hi there

Currently I am getting the following message:

"The operation failed. There are too many indexes on table 'Orders'. Delete
some of the indexes on the table and try the operation again."

In my table, I am trying to change a text box into a multi=select combo box.

There are 45 fields in my table of which 40 have this multi-select combo box.

I don't understand where these indexes are being created.

I do have 1 primary key in my table.

Thank you

My guess is that these combo boxes have indexes of their own which contribute
toward the form's index count.

I would *VERY STRONGLY* suggest that putting combo boxes into a table -
particularly multiselect combo boxes - is a major misuse of Access, and that
it is unnecessary!

Table datasheets are becoming more complex with recent releases of Access, but
they're still *very limited*. There is nothing that you can do with a
complicated table that you cannot do with simple, properly normalized tables,
and a well designed Form. You do NOT need multiselect combos, or any combos at
all, in your Table in order to do so.
--

John W. Vinson [MVP]