I have a products portal on sort of an invoice program. It works fine. What I am trying to is I have another table called payouts that references values from the portal. In the payout table I have a field called EB1Sales. That value is the same value that is in say portal row 5 in the total sold field. I have many fields in the payout table that do this.

Dave

I don't understand your data model. Could you be more descriptive of the tables and their relationships and purpose.

For example, "I have a products portal on sort of an invoice program." Huh? Do you have an Invoice table and an Invoice Line Items table? Do you have a Products table and how is it related to the Invoice Line Items table?

When you say "Invoice Program" do you mean that you have a Filemaker solution for invoicing that consists of a Filemaker file that has many tables?

I don't understand your data model. Could you be more descriptive of the tables and their relationships and purpose.

For example, "I have a products portal on sort of an invoice program." Huh? Do you have an Invoice table and an Invoice Line Items table? Do you have a Products table and how is it related to the Invoice Line Items table?

When you say "Invoice Program" do you mean that you have a Filemaker solution for invoicing that consists of a Filemaker file that has many tables?

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.

I apologize for the previous explanation