Hi Gary,

>if you don't particularly need a local view, why not just directly use the table?

It seems like when I first wrote this app I was under the assumption that it would be easier to switch down the road to SQL Server if I designed the forms using local views. Am I in mistaken on this one?

>It might be better to try and find out why you are getting duplicate keys generated.<

I think you are correct here. It happens so seldom, but in every instance it has been a child local view that that was had the problem.

Mel Cummings