I have an issue regarding the creation of related record based on a portal field. I've been lurking the Filemaker community boards for almost a year, but this solution I'm building for work has me stumped. I have been attempting to fix this for more than a week, and it's the last piece I need to complete my very first solution. I have attached a PDF image with the following information about my issue:
1. A diagram of my desired workflow with the layouts in question.
2. Text about the issue itself, the problem I aim to solve, the goal of it's function, and a description of the scripting I attempted to solve the problem
3. The underlying relationships between the tables in question
Any feedback is well appreciated,