Thanks for your input Sytze! I hadn't thought about the AutoInc type field. But, I was wondering - with that type of field - can you set it to a specific value? I don't think I have actually used this type of field before - or definitely not for a long time.
-K- -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Sytze de Boer Sent: Wednesday, February 03, 2010 1:47 PM I have had identical problems to what you describe. My scenario was a little different where there were some 15-20 users creating invoices and/or purchase orders and/or general ledger entries. All required a unique id number I overcame the problem by using a table with an AUTOINC field I haven't encountered this problem since. On Thu, Feb 4, 2010 at 5:46 AM, Dave Crozier <[email protected]> wrote: > Kurt, > Also take a look at: > http://fox.wikis.com/wc.dll?Wiki~IsWindowsReallyMadeForVFP-styledDataMan ipul > ation? > > Or > http://tinyurl.com/yd8zdm6 > > Dave C _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/289ea162f5642645b5cf64d624c66a14071a1...@us-ny-mail-002.waitex.net ** 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.

