1 Reply Latest reply on Apr 13, 2012 2:15 AM by user16671

    Create a set of Related Records via script

    user16671

      HI,

       

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

      Following Table Structure I wish to implement in FileMaker:

       

      tblSalesHeader

      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

       

      tblSalesLine

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

      1 1.07 Coca-Cola ...

      1 1.05 Fanta ...

      1 1.9 Sprite ...

      ...

       

       

      tblProductTemplateCategory

      ID CategoryName

      1 Soft Drinks

       

      tblProductTemplateCatLine

      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!