Re: Is there a better way > Auto Enter Serial Number in FMPro 9?
- From: d-42 <db.porsche@xxxxxxxxx>
- Date: Sat, 29 Sep 2007 14:45:31 -0700
On Sep 29, 11:26 am, EJay Corvette <Eric.J.Merch...@xxxxxxxxx> wrote:
I've been searching for a couple days now for the solution to
resetting the "Record Number" in my database. The Record Number is a
Serial Number and should increment by 1.
The problem I'm having is whenever a record is deleted (usually the
last record entered), my numbering is off, and I have to manually
reset the Serial Number before someone inadvertantly starts a new
record.
For example, if my records are 09, 10, 11, 12, and record 12 is
deleted, the Serial Number will then install 13 as the next available
record number.
I was able to locate this simple looking enough script from the web:
Enter Browse Mode []
Allow User Abort [Off]
Show All Records
Unsort Records
Go to Record/Request/Page [Last]
Set Next Serial Value [Client Records::Record No + 1]
The problem is, I can't get it to work. Anybody out there have a
solution?
Well, the allow user abort is superfluous. The rest of the script
looks fine; except that it appears that you haven't specified which
field to set next serial value. You've told it what to set it *to*,
but not what to set.
The bigger question is -why- are you doing this? The need to reset
serial numbers, except after an import, is usually a design error.
There are cases where its justified. But for the most part, we only
require that serial numbers be unique, not sequential with no gaps in
the numbers.
An exception, for example, might be invoice numbers, where you don't
want gaps, but in that case its usually better not to be able to
delete records at all, period. If a record is created that you don't
want, mark it as void. Or alternatively, don't assign it an invoice
number until you are sure you want to keep it. (Assign it an order
number or reference number until your sure its a keeper.)
-cheers,
Dave
.
- Follow-Ups:
- References:
- Is there a better way > Auto Enter Serial Number in FMPro 9?
- From: EJay Corvette
- Is there a better way > Auto Enter Serial Number in FMPro 9?
- Prev by Date: Re: Is there a better way > Auto Enter Serial Number in FMPro 9?
- Next by Date: Re: Search across multiple Filemaker 6 database files on Mac 10.4
- Previous by thread: Re: Is there a better way > Auto Enter Serial Number in FMPro 9?
- Next by thread: Re: Is there a better way > Auto Enter Serial Number in FMPro 9?
- Index(es):
Relevant Pages
|
