(NEWBIE) Copy record between tables in a condition
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.
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