I have another indexing hiccup. When users add rows to a table the relational is not updated. However, a rebuild will correctly update the entries. I have run into this before but have checked the things I remember and have not found the problem.

Removed the index and added it back via dbManager.

Checked the *INDEXES row in the !bang file and the index shows up.

Removed the index manually and added back via dbManager.

Saved another entry and checked the target field (no entry).

Checked the !source table*0 row and could not find an entry for the relational. So its no wonder why flushing indexes does not update the target row.

It would seem that the process of saving the source row is not creating the entry for the relational. Any ideas? Could another index be messing this up?

Thanks,

John

Ok didn't give up… Removed all indexes from table. !bang file remained… manually deleted !bang file and put indexes back on. Saved db. Indexing now works.

before deleteing the !bang file I noticed that the "!" record contained a reference to the !bang*media*application. The media was not correct and the only way of clearing this was to delete the !bang file.

Is this something that sould be checked for when adding indexes to a table?

Thanks,

John

View this thread on the Works forum...