Re: FMP question
Re: FMP question
- Subject: Re: FMP question
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 02 Nov 2000 01:23:53 -0800
On 11/1/00 1:59 PM, "Shane Stanley" <email@hidden> wrote:
>
tell database 1
>
tell layout y
>
try
>
set x to record 1 whose cellValue of cells = {b, f, c, d, e}
>
on error
>
set n to ""
>
end try
>
end tell
>
if n {b, f, c, d, e} then
>
tell layout x
>
create new record at end with data {a, b, c, d, e, f, g}
>
end tell
>
end if
>
end tell
>
>
That should speed things up quite a bit.
This method is excellent. I'm so new to FMP I hadn't realized that the new
layout doesn't get in the way of the more elaborate layout with its
calculated fields. It's quicker than the 'do script' method which I was
reluctantly going to resort to. (Although the person I'm doing this for
would still like me to do that, so he can change his FMP script at will,
without me.)
Now to tackle your fields method
--
Paul Berkowitz