Create a set of Related Records via script

[user16671]

HI,

just as 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!

[Ocean West]

here is a few tips:

http://www.filemakermagazine.com/videos/filemaker-fundamentals-creating-records.html

[user16671]

Hi,

thanks for your reply, what do you mean with a few tips?

I only see one statement, one reply and commercial Videos.

Did I miss something?

Thanks

[mr_vodka]

There should be a video on the right hand side.

[Lee Smith]

Hi user16671 and welcome to the forum.

In order to see this video, you have to be a subscriber to ISO FileMaker Magazine as the video is Subscribers only! it is worth the price of subscription to have access to the different videos available on this available on this site. You can however, watch the previews by clicking on that article option.

I would also recommend that you read About Creating Relator Records, Creating Scripts and Auto Fill in your User Manual.

Lee

[user16671]

Hi Lee,

many thanks!

I already bought the subscription yesterday (but waiting for activation) Once I review them I'll give it a try.

Regards