Hello,

I'm trying to archive data from both the parent form and its subform into another section, so that we can look back on old records. As a result, I created a function in which you can click a button on each record to archive it. However, only the fields in the parent form can be archived, NOT in the subform. Any advice? This is what I have so far:

void deleteRecord(int ID)
{
    fetch  =  Part_Information_Input  [ID == input.ID];
    insert into Archive
    [
        Added_User = zoho.loginuser
        Product = fetch.Product
        Oracle_Part_Number = fetch.Oracle_Part_Number
        Part_Number = fetch.Part_Number
        Description = fetch.Description
        Part_Weight_g = fetch.Part_Weight_g
        Pre_Consumer_Recycled_Content = fetch.Pre_Consumer_Recycled_Content
        Post_Consumer_Recycled_Content = fetch.Post_Consumer_Recycled_Content
        Scrap_per_Part_g = fetch.Scrap_per_Part_g
        Nanomaterial = fetch.Nanomaterial
        Formula = fetch.Formula
        File = fetch.File
        Approved = fetch.Approved
        Email = fetch.Email
    ]
    delete from Part_Information_Input[ ID == input.ID ];
}