AnsweredAssumed Answered

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

Question asked by ras75 on Jan 24, 2012
Latest reply on Jan 24, 2012 by philmodjunk

Title

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

Post

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

Outcomes