>Mark,
>
>Thanks for the help I switch it to TABLE buffering before the BEGIN TRANSACTION. I'm beginning to like this VIEW stuff after all. I didn't use it in 3.0 because of legacy code and sharing with DOS. However, by 5.0 I had created so much code that switching was going to be too time consuming. Now, I'm biting the bullet to prep for future SQL Server work.
>
>I have been doing all kinds of trials and tribulations trying to figure out the best ways to do things.
>
>Congrats on the upcoming boy as well. My niece cried and cried when my nephew was delivered because she wanted a sister as well. It took several hours to calm her down. She kept telling my sister to send it back! Send it back! :-)
Rick,
It happened to me a while ago, and as you found out this is an index related stuff. In my case I was using the same view two times in different bizness objects on the same form. The problem was that the views were indexed 2 times and this produced 2 different indexes on the same field, enough to make the RI code bomb ! The trick is to bracket the indexing as follows :
IF EMTPY(TAG(1))
INDEX ON … TAG …
ENDIF
José