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.