Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #565

Re: Relationship, scripting data copy

Show all headers | View raw

Matthew Buck <matthew@reflectingdesign.com> wrote:

> Consequently I am trying to configure my database such that I can move
> Quote data from a Quote Table to an Order Table at that point when a
> Quote becomes an Order.

I did the same 5 years ago with FMP 8.
 
> My thought, through a button on Quote Form, is:
> 
> Open New Window
> Create New Record: ORDER, layout Order Form
> Set Field - target (ORDERS field name), calc (QUOTE field name).
> 
> ... and Set Field for all the field data to transfer.
> 
> It does not work.

I haven't tried to understand all those relations you made, just give
you my simple approach:

From the quote: GTRR to the quot line items, if any
Leave them as they are and go to the order layout
Create new order record
grab the key in a variable or global field
go to the layout with order line items
import the quote lines (see 2)
use replace field contents to assign the foreign key for the order
go back to the order layout

-- 
http://clk.ch

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

Thread

Relationship, scripting data copy Matthew Buck <matthew@reflectingdesign.com> - 2012-01-23 22:36 -0800
  Re: Relationship, scripting data copy clkaufmann@gmx.ch (Christoph Kaufmann) - 2012-01-24 08:15 +0100

csiph-web