3 Replies Latest reply on Jun 1, 2011 9:15 AM by philmodjunk

    Extract Field Value from Portal Row

    tbcomputerguy

      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