Populate records on imported tables from MS Access

I imported 2 tables from MS Access into Zoho creator. One table whose form was the main form and the other table formed the basis of the subfrom in MS Access.

Now imported in zoho creator these 2 tables from MS Access are disjointed ie. if i click a record in the main form, the subform doesnt populate. Can someone show me the code when i edit the record in Zoho creator to be able to pull up all the data related to the mainfrom? Below is the information you can start with:

Zoho Creator

Form A has First Name, Second Name, name of child, Sponsor Id as fields. Form A is the main form.

Form B has Date of Payment, Next Payment date and Sponsor Id as fields. form B is the subform.

When someone edits the record in form A, the rest of the details in form A and details on Form B should be shown.

I have tried the fetch record with collection and its duplicating the record in the subform everytime someone edits the same record in form A.

Below is my code at present:

fet = Donation[Sponsor_ID == input.Sponsor_ID];

col = Collection();

for each i in fet

{

r = Sponsor.Donations();

r.Sponsor_ID=i.Sponsor_ID;

r.Notes=i.Notes;

r.Statement_Date=i.Statement_Date;

r.KAmount=i.KAmount;

r.Paid_Up_To=i.Paid_Up_To;

r.DAmount=i.DAmount;

col.insert(r);

}

input.Donations.insert(col);