How to add child table records from main table form?

[furkizio]

Dear community,

I have an app with purchases and sales. When i create sales order, i can see order details and click to add. See picture 1. However the same thing i cannot do for purchase orders. See picture 2. I checked columns etc. they have the same set up. Details in both table are List column type and connected with Ref_Rows function. After saving header info for purchases, i can see add function. see picture 3.

Anyone can suggest what to do?

[hru · Accepted solution]

The “ADD” on the 1st picture is due to relation between Order Table and Order Detail Table sets with IsPartOf = ON.

However, A table can only have one Ref column marked IsAPartOf (a row can only be a part of one other row).

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so your data makes sense.

[furkizio]

Thank you very much. I missed this function obviously.