>I HATE SOCCER.......
Then you should move to Canada :) - unless you hate hockey too.

>If using the proper code and wrapping it in a transaction, not much could go wrong. In fact the VFP RI builder, does do quite a good job (besides performance could be better).

Using the proper code is always my biggest challange.

>Hmmm, so you're saying that previously you didn't ? Well using generated PKs do solve a lot of problems, but be ware of cases where they are not as handy as intelligent keys.

It's not all my doing, when I came the system was already 10 years old.

Thanks,
dz