D
Doctor
my table tblClients has too many indexes. I've deleted and deleted indexes
just to make the tables that I absolutely must enforce RI. Some I will just
have to do in the form setup. I'm almost there. The only index that I still
have showing in the indexes table is the primary key. All of the rest are
only in jet.
I think I can make it if someone can help me with this. I noticed with a
list of all indexes printed in the Immediate window that it lists it like
this:
tblClients
PrimaryKey
ClientID
tblBPSInfotblClients
ClientID
tblClientsClientChurchPositionID
ClientChurchPositionID
tblClientsClientTitleID
ClientTitleID
tblClientsGenderID
GenderID
tblClientsMCTitleID
MCTitleID
tblClientstblClients
ClientChurchID
tlkpClientClubStatustblClients
ClientClubStatusID
tlkpClientOrigintblClients
ClientOriginID
tlkpClientTypetblClients
ClientTypeID
Can I delete the ones that reference the table of the foreign key? For
instance, could I delete the ones that start with "tbl*"?
Thanks for the help.
just to make the tables that I absolutely must enforce RI. Some I will just
have to do in the form setup. I'm almost there. The only index that I still
have showing in the indexes table is the primary key. All of the rest are
only in jet.
I think I can make it if someone can help me with this. I noticed with a
list of all indexes printed in the Immediate window that it lists it like
this:
tblClients
PrimaryKey
ClientID
tblBPSInfotblClients
ClientID
tblClientsClientChurchPositionID
ClientChurchPositionID
tblClientsClientTitleID
ClientTitleID
tblClientsGenderID
GenderID
tblClientsMCTitleID
MCTitleID
tblClientstblClients
ClientChurchID
tlkpClientClubStatustblClients
ClientClubStatusID
tlkpClientOrigintblClients
ClientOriginID
tlkpClientTypetblClients
ClientTypeID
Can I delete the ones that reference the table of the foreign key? For
instance, could I delete the ones that start with "tbl*"?
Thanks for the help.