Re: Copy data from table through a relationship - set field

From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	Re: Copy data from table through a relationship - set field
Date	2012-01-25 22:26 +0000
Organization	slrn user
Message-ID	<slrnji10d6.7a.t-usenet@ID-685.user.individual.de> (permalink)
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>

Show all headers | View raw

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

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Copy data from table through a relationship - set field Buckbuck <buck.matthew74@yahoo.com> - 2012-01-23 22:54 -0800
  Re: Copy data from table through a relationship - set field Martin Τrautmann <t-usenet@gmx.net> - 2012-01-24 08:17 +0000
    Re: Copy data from table through a relationship - set field Buckbuck <buck.matthew74@yahoo.com> - 2012-01-24 07:10 -0800
      Re: Copy data from table through a relationship - set field Martin Τrautmann <t-usenet@gmx.net> - 2012-01-24 15:28 +0000
        Re: Copy data from table through a relationship - set field Buckbuck <buck.matthew74@yahoo.com> - 2012-01-25 14:23 -0800
          Re: Copy data from table through a relationship - set field Martin Τrautmann <t-usenet@gmx.net> - 2012-01-25 22:26 +0000
            Re: Copy data from table through a relationship - set field Buckbuck <buck.matthew74@yahoo.com> - 2012-01-25 14:50 -0800
              Re: Copy data from table through a relationship - set field Martin Τrautmann <t-usenet@gmx.net> - 2012-01-25 23:05 +0000
                Re: Copy data from table through a relationship - set field Buckbuck <buck.matthew74@yahoo.com> - 2012-01-25 15:24 -0800

csiph-web