AnsweredAssumed Answered

Get Value of Field from a related table from a portal row

Question asked by ToddNolan on Mar 19, 2015
Latest reply on Mar 19, 2015 by philmodjunk

Title

Get Value of Field from a related table from a portal row

Post

I have a layout from MainTable where I choose an age from a field and it shows a premium for that age for about 10 different companies. All these tables are related to the main table by age. My problem is:

I want to be able to click on company A, B, or C .... premium field (inside the portal) and save it to a field called box1 in MainTable. I've tried the Get(ActiveFieldContents) funtion but it give MainTable::box1 a blank value.

I know I can write a button script for "each" company's portal row's field and make that work, but this will be a ton of work as I add other forms of data that I'd like to save to the MainTable. Seems like there'd be a simple way to grab this info and copy it. I'm drawing a blank.

Any ideas or suggestions how i can pull the value from a portal row and save it to a global field in my MainTable?

 

Thanks for your advice guys!

Outcomes