AnsweredAssumed Answered

Create a set of Related Records via script

Question asked by user16671 on Apr 11, 2012
Latest reply on Apr 13, 2012 by user16671



just an an introduction, I'm new in the FileMaker world.

Following Table Structure I wish to implement in FileMaker:



ID Date Product Template Category (this includes a predefines set of Products, which will be defined on another Form)

1 01/01/2012 Soft Drinks



SalesHeaderID Price $ Product (coming from the above selected (Product Template Category)

1 1.07 Coca-Cola ...

1 1.05 Fanta ...

1 1.9 Sprite ...





ID CategoryName

1 Soft Drinks



ProductTemplateCategoryID ProductID ...

1 Coca-Cola

1 Fanta

1 Sprite



What I want now is to find a way to pre-populate (via script I guess?) the SalesLine Records in accordance to the Product Template Category's Product Mapping (Coca-Cola, Fanta, Sprite...) resulting in three lines in my example.


Any Ideas how this could be achieved elegantly with FileMaker?

I'm using FileMaker Pro 12 Advanced.


Many thanks in advance!