Re: Auto increment number field in FMP
Re: Auto increment number field in FMP
- Subject: Re: Auto increment number field in FMP
- From: Tim Mansour <email@hidden>
- Date: Tue, 25 Sep 2007 08:45:48 +1000
On 25/09/2007, at 7:17 am, Kevin Muldoon wrote: I am launching a new FMP db project today. I was noticing that the ID of each record appears to be +1 more than the UniqueID auto-increment field I created so I suspect they are related. Can I reliably depend on this fact throughout the life of the database? It's FMP7.
The unique record ID is assigned internally by FM and stays the same for the life of the record. Your own auto-enter serial-number field is completely unrelated: any ostensible connection is coincidental.
In older versions of FM the record IDs were not always sequential (eg, there was a jump from 127 to 32768) but that was fixed in FM7.
If you did want to use the record ID as your serial-number field you could auto-enter the Get(RecordID) calculation. But I suspect you don't want to do that if you're launching today :-) set r to record ID of every record in table "table1" whose cell "UniqueID" = 3
That statement should work fine so long as you replace "record ID" with just "ID".
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden