AnsweredAssumed Answered

Auto create a record in a related table?

Question asked by KimSpurlin on Aug 18, 2018
Latest reply on Aug 19, 2018 by KimSpurlin

I have used FileMaker for over 25 years, however it has been on the user end.  However the solution was very simple, only one table, so I know how to make layouts and move fields around.  I don't know much about relationships and scripts.


I am now trying to use FileMaker for my jewelry business and am running into some problems.


I have related tables Products and Etsy.  I'm trying to create a new record in Etsy at the same time that I am creating a record in Products using the Product IDpk to Product IDfk, and nothing I've tried has worked.  I've seen scripts that have Set Variables and Set Field, but I keep getting an error.


Below is my relationship graph.


The product table is using a portal from the Line Items table, which hopefully I did correctly.


If anyone could please help me with this I would greatly appreciate it.