Updating the Line Item with Script

[gullfounder]

Hi,

I was having a bit of problem in FileMaker Scripting. I made a script that as spouse to update each field in each row in Line Portal but it only updates the first rows field. When i insert new row it updates the first rows filed.

I have attached the Script image. Kindly help me solve the issue.

Thanks

[gullfounder]

I have searched on internet and found the answer myself. After going away from the lineRow the FileMaker does not remember the row number. So, I have to save it in the variable. So, i can get back to it. I used the function "Get(ActivePortalRowNumber)" to get the active row number. After coming back to the layout used that variable to find that same row.

http://www.filemaker.com/11help/html/func_ref2.32.10.html

[Vaughan]

Lots of problems there. Don't use quick find, it will find the ID in fields other than the id field.

Use the Go to Related Records step to find the related records. Do this in a new window so the current window is not disturbed.