In previous posts, I was asking for assistance in creating a Case Management
Datatabase.

In this database, there are 5 categories of investigation:

School, Community, Individual, Peers, and Family.

In the School category, there can be anywhere from one to seven actions a
youth can take depending on how he has answered previous questions.

For instance, if the youth answered that he has no role models, then the
reaction is to help the youth obtain positive role models, positive support,
and/or Empowerment but not necessary all can/would be chosen.

All this information is hopefully placed in a form in which at each phase of
their involvement in the program, all their youth's responses can be reviewed.

If I split up my form into the categories by phase, this can mean an
additional 25 tables.

This would bring my total tables to almost 100.

I can't create any more relationships since I am at the limit.









"forest8" wrote:

When I check the indexes, there are only 2 indexes created:

One is the tables' primary key and the other is the Foreign Key.

I can't seem to see any other index.



"Jeff Boyce" wrote:

First, be aware that the general consensus among regular Access users is
that more than about 30 fields in a table is fairly unusual, and usually
indicates that the table/database needs a bit more normalizing.

Access adds indexes of it's own, "behind the curtain" so to speak. Have you
opened the table in design view, clicked on the Indexes button and inspected
what indices are showing?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"forest8" wrote in message
...
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


.