>>I have a group of 4 seeks. The second seek is firing the record Validation rule on my table. Has anyone ran into this? How to I prevent this from happenning. I changed it to indexseeks and the fourth indexseek then fired the record Validation rule on my table. If you have any idea on how to get this not to occur please let me know.
>
>Thats because moving the record pointer in a row buffered table, cause an update to occur. You can try what Cetin suggested (which aviods moving the record pointer) or you can try table buffering instead of row buffering.
Hey Mike,
I could be completely wrong here, but I don't think table buffering has any effect on when a table validation rule fires. I think the rule fires when the record pointer moves, even if table buffering is on.
Steve Gibson