Copy and paste script out of multiple portalrows

[Jukkie]

Well here is the story.

I have two databases: Orders.fp7 and Invoices.fp7

In Invoices.fp7 I have a Table called: "Portal line items" wich contains records based upon the field: "Invoice number".

Orders.fp7 <-Fields-> Order number

Description

Order status

and

Invoices.fp7 <-Field-> Invoice number

Portal line items <-Fields-> Invoice number

Ordernumber

Description

When I finish creating a Invoice with multiple portal line items that correspond with the multiple orders from the same (single!)customer, I want to press a "confirm" button that performs a action that gives a value 1 (= processed) to the field "order status" in Orders.fp7 for all processed orders mentioned in the invoice.

To put it simple: Every processed poral line item in the Invoices.fp7 should generate a status 1 in the corresponding orders.fp7 db

Anyone

[Fitch]

Your profile says FileMaker 6, but your question refers to ".fp7" files. Do you use FileMaker 8? Your version will affect the solution.

[Jukkie]

This solutions is build in Filemaker 7 developer and will be used in a Filemaker 8 surrounding.