Posts 0

07-25-08 08:06 AM - Post#25842

hi,

im new to the forums here and new to filemaker, im using 9pro adv. and editing bits of code from the supplied business packages, i have been having a hard time solving an issue i have with moving portal data. I have a jobs database with a portal that displays line items for salewithin a "lineitems" table: quant, item, description,..etc taken from a stock database.

the portal has a checkbox at the end of each line to demote that the line is required in an invoice that is on a seperate invoice data base. i have a looping script that reads through the portal and can recreate the desired fields within its own "line items" table as temp items (not necesary but at least it shows the script works)via a list of set field functions but if i try to set field data into the external invoices db it only writes to one line item record, hence i only end up with the top line filled in in the portal within "invoices line items". it seems to me i need "invoice line items" table to create a new (related) record for each line during the set fields looping script but i cant figure out how ?

any suggestions greatly recieved.

thanks

Ben

Edited July 25, 200817 yr by Guest

use the Go To Portal Row[Last] script step ??

any idea where i might put that. the script is looping through "line items" but the portal row(last) requires it to look up the portal in "invoice line items" ?

thanks

this problem ended up being relationship related and is covered in this post....

Post#298460

thanks

Ben