Andy I have had similar problems where the Invoice number is calculated eg from an incrementing field in another table rather than being the next serial number sequence in the invoice file. Occasionally if two people try to create an invoice at the one time they could both get the same number. I have found that flushing the cache can get the revised data back to the server more reliably. In some cases I have placed a flag field in the source file that must check OK before it will allow the second user to grab an invoice number.
Best Wishes Jim Brear COAMAS Services PO Box 1542 Armidale NSW 2350 Mobile Phone: 0429 428 700 Home Office Phone: (02) 6772 3933 Fax: (02) 6771 3666 email: [email protected] COAMAS - Community Options, Advocacy, Management and Accounting Software -----Original Message----- From: FileMaker Pro Discussions [mailto:[email protected]] On Behalf Of andy knasinski Sent: Tuesday, 3 February 2009 11:27 AM To: [email protected] Subject: Re: tricky problem Lee - It's not a hardware issue, it's likely due to your hosting on FM Client. First, be sure that your host has ALL of the files open and hosted. Once you've done this, check your file references and remove any unnecessary entries - assuming all db's are located in the same folder, your references should just be File:FileName.fp7 Your data is likely not "lost" - it's sitting in some other Invoice file on your remote computer's hard drive. Regards, Andy On Feb 2, 2009, at 5:00 PM, FMPRO-L automatic digest system wrote: > We have two networked (ethernet) XP pc's running FM 8.5. One hosts > the > files and the other, a much older machine, is used occasionally to > create invoices remotely. We have found that sometimes an invoice > created and printed on the older machine disappears or was never > 'written/saved' to the host machine files. That invoice number is > missing while other invoices created before and after are there. This > solution auto creates the next numerical invoice number each time > one is > created. > The invoice screen will create a record in the client file if that > client has not had an invoice raised before. When an invoice is > 'missing' its interesting to note that the new client data is in in > the > client file proving the original missing invoice was created. > The bottom line is an invoice is created and printed on the remote > machine but just never appears on the host files. I'm presuming this > is > a hardware issue so if any one else has experienced this problem > before > I'd appreciate what they found to be the problem.
