How to insert multiple transactions in one transaction ID

[Andree]

Hi all, I am new in AppSheet and need help. So I have an App to record any payment transactions which I want to input the detail of the transactions per item, for example: Transaction ID A1 of $100 will be breakdown into item 1 of $50 and item 2 of $50. How can I add these multiple breakdown for this single Transaction ID?

Please refer to my purchase column and the UX.  My Purchase column is referring to a Purchase sheet which has columns to be filled. Looking forward to your responses, thanks!

[SkrOYC]

---

@Andree wrote:

How can I add these multiple breakdown for this single Transaction ID?

---

Add a new table that should be children of the Transaction table and when selecting the Ref to Transaction make sure you select the "Is Part Of?" option. In this table you should be have all the columns needed for each item.
Also change the amount column to be a virtual column or AppFormula with a SUM() that takes all the item values with a list dereference

[Marc_Dillon]

2 tables referenced together, parent and child, in a one-to-many relationship.

https://help.appsheet.com/en/articles/961426-references-between-tables

[Andree]

Hi guys, thanks for the responses. 

I have done the same by referencing parent and child table, and it works!