Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.42!gegeweb.eu!nntpfeed.proxad.net!proxad.net!feeder2-2.proxad.net!nx01.iad01.newshosting.com!newshosting.com!news-out.readnews.com!transit3.readnews.com!postnews.google.com!n15g2000vbn.googlegroups.com!not-for-mail
From: Rob <robdsteward@gmail.com>
Newsgroups: comp.databases.filemaker
Subject: Finding the portal row which was just created
Date: Thu, 6 Oct 2011 08:55:56 -0700 (PDT)
Organization: http://groups.google.com
Lines: 23
Message-ID: <65d4695c-80e7-43ab-9ca6-bcff4d6d533e@n15g2000vbn.googlegroups.com>
NNTP-Posting-Host: 67.60.67.87
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
X-Trace: posting.google.com 1317916556 14295 127.0.0.1 (6 Oct 2011 15:55:56 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 6 Oct 2011 15:55:56 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: n15g2000vbn.googlegroups.com; posting-host=67.60.67.87; posting-account=RUHvMwoAAADEFY6HA1IWDXgnGbx0e-XE
User-Agent: G2/1.0
X-Google-Web-Client: true
X-Google-Header-Order: HUARLECNK
X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_1) AppleWebKit/534.48.3 (KHTML, like Gecko) Version/5.1 Safari/534.48.3,gzip(gfe)
Xref: x330-a1.tempe.blueboxinc.net comp.databases.filemaker:416

Not sure why this seems to elude me...


I've got a Clients table related 1-to-many with an Activities table.

I've got a portal showing Activities for the client, sorted by date,
most recent on top (some dates can also be future).

I've got a script which goes to the Activity layout, creates a new
Activity, fills it with some default/current information and returns
to the Client layout.

I would now like to activate a field in the portal row containing the
Activity which was just created, so that the user can enter the
details of the Activity.

I'm about to write a brute-force looping script to examine every
portal row until it finds the right item, but it seems like there
ought to be something more elegant and/or faster and/or less likely to
break.

Any thoughts? Thanks in advance!
-Rob