How are you generating the invoice numbers - from a table holding the next number? I had a problem like this generating primary keys using a next number table on a couple of apps. It be-devilled us for years, I couldn't find what was causing it as it seemed to be intermittent - it only went away when I upgraded and started using auto incrementing fields.
Why upgrade to VFP 8, why not VFP 9? John Weller 01380 723235 07976 393631 > > > I've got a weird problem whereby I get duplicate invoice numbers in a vfp6 > native app. Does a tableupdate issue a flush at the same time? It has just > duplicated today for the second time in about a year. > > _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.