4 Replies Latest reply on May 10, 2010 10:06 AM by philmodjunk

    (NEWBIE) Copy record between tables in a condition

    WeirdMan

      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