• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Auto increment number field in FMP
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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".

-- 
Tim Mansour <email@hidden>



 _______________________________________________
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

References: 
 >Auto increment number field in FMP (From: Kevin Muldoon <email@hidden>)

  • Prev by Date: Re: Auto increment number field in FMP
  • Next by Date: Re: Creating complex HTML messages in mail via AppleScript
  • Previous by thread: Re: Auto increment number field in FMP
  • Next by thread: Incrementor no working in iCal Print window
  • Index(es):
    • Date
    • Thread