3 Replies Latest reply on Jan 24, 2012 4:31 PM by LyndsayHowarth

    BIG PROBLEM WITH PORTALS......HELP ME

    ras75

      I HAVE GOT THREE TABLES

      SHARES ORDERS CUSTOMER

      SHARE_id ORDER_id CUSTOMER_id

      SHARE DESCRIP SHARE_id

      CUSTOMER_id

      DATE

      QUANTITY

      PRICE

       

      Table SHARE is linked with ORDERS:SHARE_id

      Table ORDER is linked with CUSTOMERS:CUSTOMER_id

      One customer can do many order

      the order is not like an invoice with multi share

      in one order only one share each time

      Each share can have multi Orders

       

      My problem is that when i go to LAYOUT coustomer i need a portal where i have SHARE TABLE and in each row the total quantity of shares for that customer, and when i co to LAYOUT share i need a portal where i have SHARE CUSTOMER and in each row the total quantity of shares for each share in portfolio.

      i need also to check, when i am in LAYOUT ORDER, after had insert share_id and Customer_id a field where i had the position for that customer and for that share before and after the current order.

       

      At the moment i have got all the portals working but not for the quantity. I try muli attemps but sometimes i alway have total not mathcing. I meen or the total of the toal or the total for each customer without break for the share and something like this.

       

      Regards