AnsweredAssumed Answered

Extract Field Value from Portal Row

Question asked by tbcomputerguy on May 29, 2011
Latest reply on Jun 1, 2011 by philmodjunk

Title

Extract Field Value from Portal Row

Post

I have a control sheet program that has currently three tables, control  sheets, papertypes and control_items and some other tables.  I have a  script that pulls all related papertypes from the papertypes table when a  certain criteria is met.  I also wish to implement a payout table.  A  lot of the fields in this payout table will be the the same amount as a  calculated see the attachments.

The screenshot depicts a lower table the main control sheet and a partial of the payouts or what it should look like correctly figured out.  I think I need a table linked to the the line items.  I was thinking too that the fields I am trying to duplicate or draw data from could be in the line items table and when a new line item is created a new record is created in the payout table.  Problem is, how would the payout table know which payout item is tied to proper line items.

DAve

tableview.png

Outcomes