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

From	Buckbuck <buck.matthew74@yahoo.com>
Newsgroups	comp.databases.filemaker
Subject	Re: Copy data from table through a relationship - set field
Date	2012-01-25 14:23 -0800
Organization	http://groups.google.com
Message-ID	<0a30ef48-ab46-4c69-92e8-63bd43f9e548@k3g2000pbn.googlegroups.com> (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>

Show all headers | View raw

On Jan 24, 7:28 am, Martin Τrautmann <t-use...@gmx.net> wrote:
> On Tue, 24 Jan 2012 07:10:28 -0800 (PST), Buckbuck wrote:
> > > Obviously it doesn't. You do have a relation from the quote id to the
> > > order id? Then copy the quote id to the order id first.
>
> > > Then you may walk through your fields and do a set field (from quote-id
> > > field).
>
> > > - Martin
>
> >  What relation? Through CONTACTS? Are you suggesting
>
> >  QUOTE_kp Quote ID = ORDER_kf_OrderID ?
>
> Eactly - that's the way to copy anything from the quote table to to
> order table.
>
> If you do want to copy from the contacts table, you may use the contacts
> relations.
>
> - Martin

Thanks for your feedback.
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?

Matthew

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