>Hi Naomi,
>
>>However, the more indexes we have, the more chances for corruption, IMHO.
>
>Does your client have a problem with index corruption? If not, it seems that you are trying to solve a problem that doesn't exist. <s> In this case I'd add index refactoring to a list and take care of it later or when you encounter a problem. Keep the indexes in mind if you need to solve performance problems, though.
One of the problems, which I can not really explain, is this.
The form uses a SET FILTER. It shows records in a grid. I saw today with my own eyes (every time reproducible) the duplicate records. First one is not a dupe, then two dups. I checked two tables that may be a suspect and there were no duplicate records there.
I tried to trace the problem, but somehow either got too many distractions or too many crashes, that never really figured the reason. Also the form is modal and I'm unable to switch to command window or fire a set command.
If it's not broken, fix it until it is.
My Blog