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-24 15:28 +0000
Organization	slrn user
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>

Show all headers | 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