Get Value of Field from a related table from a portal row
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!