Groups | Search | Server Info | Login | Register

Groups > comp.databases.filemaker > #563

Relationship, scripting data copy

Show all headers | View raw

Prelim
As many know, in a business one has Quotes and Orders. Quotes might
become Orders but not necessarily. Quotes have many of the same data
fields as Orders, however, creating Quotes on the Orders Table is
problematic. Depending how much quoting you do you might find your
Order database over populated by quotes, dead or otherwise. When you
use an auto-entered serial or numbering system then you end up with
many redundant Order/Quote numbers.

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.

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 am not sure whether the New Record is referencing the current QUOTE
record.

My relationship tables look something like this:

CONTACTS_kp_ContactID - ORDERS_kf_ContactID
ORDERS_kp_OrderID - LINES_kf_OrdersID
PRODUCT_kp_ProductID - LINES_kf_ProductID

CONTACTS_kp_ContactID - QUOTE_kf_ContactID
QUOTE_kp_QuoteID - LINES_QUOTE_kf_QuoteID
PRODUCT_kp_ProductID - LINES_QUOTE_kf_ProductID

Since there is a common denominator in both - CONTACT_kp_ContactID, is
this possible?



Thanks
Matthew

Back to comp.databases.filemaker | Previous | Next — Next 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