Jump to content

Copy and paste script out of multiple portalrows


This topic is 5691 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5691 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.