AnsweredAssumed Answered

(NEWBIE) Copy record between tables in a condition

Question asked by WeirdMan on May 7, 2010
Latest reply on May 10, 2010 by philmodjunk

Title

(NEWBIE) Copy record between tables in a condition

Post

Hi, I'm completely new to FileMaker Pro. I'm using FMP 11 trial in mac.

 

I want to copy a record to specified table everytime I create a record.

For example:

Table 1: items

item date buy use

 

Table 2: T Shirt

date buy use

 

I want to copy records I create when I use a layout using "items" table, so if the "item" field is "T Shirt" then the record is copied to table 2.

 

Or another alternative, can I create a layout field so when I insert "T Shirt" in "item" field, then that record is on T Shirt table, and when I insert "Polo Shirt" then the record is on "Polo Shirt" table

Outcomes