BIG PROBLEM WITH PORTALS......HELP ME
I HAVE GOT THREE TABLES
SHARES ORDERS CUSTOMER
SHARE_id ORDER_id CUSTOMER_id
SHARE DESCRIP SHARE_id
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.