Have you looked for a filtered INDEX TAG?


>I have a database container 'SA' that includes a table 'saTests.dbf'. Previously, the table had the alias of 'Tests' but when I migrated the app to VFP7, I started having a problem with a form that had this table in its DE. When the app was run, the form could not find the 'Tests' table in the database and a dialog would come up requiring the user to locate the table.
>
>In an attempt to correct this problem, I changed the alias of the table back to the default alias which corresponds to the name of the file (satests). I also modified the form to change all references from 'Tests' to 'satests'.
>
>The form runs fine in the VFP7 environment but when the form is run from within the app, I get the same locate dialog that still wants the user to locate the Tests table. saTest in now in the DE of the form and its alias there is saTests, I have hacked the form and have found no references to the 'Tests' table, and I have even hacked the database container and have found no references to 'Tests' there either.
>
>I use SDT to maintain the Database and tables and have found nothing that looks amiss there.
>
>When I do a validate database, I get an unexpected dialog. First 2 lines are written to the screen:
>
> Validate database SA:
> Rebuilding structural index.... Index rebuilt.
>
>Then a VFP7 dialog comes up, "Alias 'SATESTS' is not found"
>
>After clicking on the OK button, another line is written to the screen:
>
> Database container is valid.
>
>satests is, of course, a table in the database as discussed above.
>
>Does anyone know what going on here? Obviously, something has gotten corupted. Any suggestions on how this can be repaired?
>
>Thanks very much,
>Stan