<div>
Sure that the index isn't already present?<br />
Normally I use always a DROP followed by an ADD.<br />
<br />
Nic;o)<br />
<br />

</div>


Sure that the index isn't already present?
Normally I use always a DROP followed by an ADD.

Nic;o)



<div>
JDettman,<br />
I think that might be it. What's RI?
</div>


JDettman,
I think that might be it. What's RI?

<div>
Referential Integrety, you can specify on the Relationship form.<br />
Just check by opening the table in design mode and select Tools/Indexes.<br />
<br />
Nic;o)
</div>


Referential Integrety, you can specify on the Relationship form.
Just check by opening the table in design mode and select Tools/Indexes.

Nic;o)

<div>
<div class="content wysiwyg-content">
i'm running this sql:<br />
<br />
alter table rgcnseq3_gcnseqno_mstr<br />
add constraint rgcnseq3_rhiclsql<br />
foreign key (hicl_seqno)<br />
references rhiclsq1_hiclseqno_mstr<br />
(hicl_seqno);<br />
<br />
and i get the message<br />
<br />
...too many indexes on rgcnseq3_gcnseqno_mstr...<br />
<br />
what does this mean?
</div>
</div>


i'm running this sql:

alter table rgcnseq3_gcnseqno_mstr
add constraint rgcnseq3_rhiclsql
foreign key (hicl_seqno)
references rhiclsq1_hiclseqno_mstr
(hicl_seqno);

and i get the message

...too many indexes on rgcnseq3_gcnseqno_mstr...

what does this mean?

too many indexes

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.