Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!.POSTED!not-for-mail
From: Martin =?UTF-8?Q?=CE=A4rautmann?= <t-usenet@gmx.net>
Newsgroups: comp.databases.filemaker
Subject: Re: Copy data from table through a relationship - set field
Date: Wed, 25 Jan 2012 22:26:46 +0000 (UTC)
Organization: slrn user
Lines: 22
Message-ID: <slrnji10d6.7a.t-usenet@ID-685.user.individual.de>
References: <97d03d6d-c1ff-4cc0-8453-9a3474522f43@b10g2000pbd.googlegroups.com> <slrnjhsq8m.gcg.t-usenet@ID-685.user.individual.de> <4d7d5123-7a60-4c74-a6f2-b69993358b12@b10g2000pbd.googlegroups.com> <slrnjhtjhd.7a.t-usenet@ID-685.user.individual.de> <0a30ef48-ab46-4c69-92e8-63bd43f9e548@k3g2000pbn.googlegroups.com>
Reply-To: traut@gmx.de
X-Trace: news.albasani.net D3PE1X5pu9C7s7nMeJFRLialuYZaTj4TbS19HMZzSVP5PqNo4lQnA5KKZfZxZ9AiqRlk9iWEYcxZV0g+DJ+6O8LRyNvETGRlz7eTrpChN+05yIIzcZ1AI5bQy0Y2bhTN
NNTP-Posting-Date: Wed, 25 Jan 2012 22:26:46 +0000 (UTC)
Injection-Info: news.albasani.net; logging-data="RBQLIVMGOe/F/sfikpPFiyW4Si6x9+nzPUSLwyIXxmx7GfrOiLZKbUH3u2894MOd3g1vzAoHmU1SOJRNdIsqL9Gc8xje5BiStLfbJnD9h4aseAOFbefnVqlW/N9pFBFW"; mail-complaints-to="abuse@albasani.net"
User-Agent: slrn/pre1.0.0-18 (Darwin)
X-No-Archive: Yes
Cancel-Lock: sha1:VrUOZag5hfFqOvgmAEL93zdyz9A=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.filemaker:579

On Wed, 25 Jan 2012 14:23:18 -0800 (PST), Buckbuck wrote:
>  So far so good. One part of the undertaking I am having difficulty
>  with concerns the Lines portal. When I Set Field, Lines_Order, Sku;
>  Lines Proforma, Sku , only the first record is copied. I kind of
>  understand why but do not understand a work around. Can you give
>  advise me?

Set Field does work on the current record only - which would be your
first, usually.

Choices:
- use "Replace Field Contents" which does work on all active (found)
  records

- use a loop construct
   goto first record   
   loop
     set field
     goto next record (exit on last)
   end loop

Martin