You will need a bit of ERD knowledge. You are doing the JOIN from parent form to subform form. What is the relationship between them? Can you share the subform properties > data linkage?

Thank you for replying Bastiana 

Here is what I have.

My main form looks like this, with a subform repeater linking to my second form that I will use as the subform.

So, what I want in my data list is to store the entered subform data.

The subform repeater is called field1.

The subform looks like this, I also added a hidden FK field as the foreign key:

For the subform data linkage, I put this:

But how do I link the sub-form to the parent form (subform repeater)?

I did this to link the subform repeater to the subform via the FK field:

But what am I missing here?  Any help is much appreciated - thank you!

Matthew King Bastiana Can anyone kindly help me with the missing piece of this puzzle?

Thank you!

Can anyone kindly point me in the right direction on this please?

Thank you!