Invisible Indexes

[sparrow]

I have a Crystal report that fails when run in Tokyo, but is ok when I run it in Hong Kong. The error I get is POrdersInvoices is not a valid index.<br>
<br>
When I look at the indices for the table this index can not be seen. Using documenter I checked the table and the index is mentioned.<br>
<br>
Why can I not see the index in Access

 

[elizabeth]

Are you looking for the index just by looking at the table in design mode, or by looking under View/Index? If you don't see it in either place perhaps your table object is corrupt. You could try exporting and re-importing it into the database, or building a new index with the same name.

 

[DreewToo]

I agree, <br>
<br>
The name of the index in the View/Index area of the table design mode is set by the user, and sounds like a primary index composed of the PO# and Invoice #. <br>
<br>
Good luck

 

[sparrow]

Thanks for the information. I will check this out next year<br>
<br>
<br>
Sparrow