>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.
After lots of probles of this sort, I decided to forget about field/record level validation. I currently do all validation in methods called up from froms, or in triggers. Works fine.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)