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

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

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