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.
Thanks in advance!