AnsweredAssumed Answered

Create a New Record in a table then load information from portal row in a different table

Question asked by dansan500 on Feb 10, 2011
Latest reply on Aug 21, 2011 by MonikaJost

Title

Create a New Record in a table then load information from portal row in a different table

Post

I have the following senerio:

Table (PurchaseOrder) for the layout = po#, who pruchased from etc....

Table (PurchaseOrderLine) for the portal rows, Item#, cost, Description .. ect..

    IN RECEIVING

           Layout using the (PurchaseOrder) table w/ portal rows using Related (PurchaseOrder PurchaseOrder_Status Open)

           So it list all open Purchase orders. (in each row there is a small button, when selected, opens a POPUP showing

           Line items on the PO. The popup layout uses (PurchaseOrderLine) table. - everything works great up to this point.

     HERE is MY PROBLEM:

           On a button at the end of each portal item row is designed to Create a NEW RECORD in a table called (RECEIVING)

    (1) it is suppose to load the information on the line item Portal row (PurchaseOrderLine) to (RECEIVING)

    (2) each item row in the portal has a unique Line item# field..

    (3) What I have tried, was using the Line Item# and the Purchase Order# as my relational fields

I can't figure out how to create the New Record in the RECEIVING table and load it with the portal row information from the (OurchaseOrderLine) table..

Can you help PLEASE.....

ScreenShot.jpg

Outcomes