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

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!.POSTED!not-for-mail
From	Martin Τrautmann <t-usenet@gmx.net>
Newsgroups	comp.databases.filemaker
Subject	Re: Copy data from table through a relationship - set field
Date	Tue, 24 Jan 2012 15:28:45 +0000 (UTC)
Organization	slrn user
Lines	20
Message-ID	<slrnjhtjhd.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>
Reply-To	traut@gmx.de
X-Trace	news.albasani.net 7pBXEoHPDMnwi9MwqkOCTci2csLekUimAMiLw8xh4CZ/KQaZAcWJYrEH2d5CljJ23+6aws2TinOZJ/JI3a5PAjGZ+6i12WJvDk87HpdNj4xPqYoxPA99+oHpbZH4RMZ/
NNTP-Posting-Date	Tue, 24 Jan 2012 15:28:45 +0000 (UTC)
Injection-Info	news.albasani.net; logging-data="ZiWIs/xn5hwPAYLo+S2Xi0DzSOglejAs6K7A+GrHVvNRVCG3DzCSJSqQ4VMiUrDJJULmpTTE0HW72xV9ObytWDG+v9pkeQ9xAgH2j93ksKDYCBmA4a2h9slwiEeWfEYl"; mail-complaints-to="abuse@albasani.net"
User-Agent	slrn/pre1.0.0-18 (Darwin)
X-No-Archive	Yes
Cancel-Lock	sha1:dWrRdrpqEzpk9rHWrcaTZZipYkc=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.filemaker:571

Show key headers only | View raw

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

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