AnsweredAssumed Answered

How to make a parent and child portal work?

Question asked by tjtalusan on Aug 1, 2012
Latest reply on Aug 1, 2012 by LyndsayHowarth

So I have 2 tables which is a parent and a child table and they are related to an ID which is 1 to many respectively. So i setup the 2 portals in the layout 1 for the parent and 1 for the child. The idea is all the items I will add in the parent will be part of a dynamic dropdown list with the child portal. My only issue here is that, every time I add an item to the child it only refers to the first record in the parent portal(table).

How can I make the child portal refer to the dynamic dropdown list and use that as an ID in my child table? And also do a count or sum for that specific parent ID.

Below is an example on what I would like to achieve.

 

 

Parent:

IDCustomerTotal Orders
1Acme15
2Sierra8

 

 

 

Child

CustomerItem
Order Qty
AcmeApple10
AcmeBanana5
SierraApple8

 


Thanks in advance!

Outcomes