ras75

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

Discussion created by ras75 on Jan 24, 2012
Latest reply on Jan 24, 2012 by LyndsayHowarth

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