How can I get subform values in a data list?

 
1
0
-1

Hello Everyone.

I have a main form that is a multi-page form that consists of other form pages.

I want all these values in a datalist, but, it seems, by default, I only get the fields from the main form.  Nothing is available to drag and drop from any subforms.

What is the process to link the subforms to the main form to be displayed in a datalist?

I've looked at this - Advanced Form Data Binder

But I am not quite sure how to fully configure it.

For example:

TESTFORM - this is my main form.

TESTFORM2  this is my subform.

TESTFORM has a subform repeater on it that links to TESTFORM2.

How do I get the values entered from TEST_SUB into a data list?

I am not sure how to set up the grouping.

image-2023-8-28_14-29-40.png

Any help is much appreciated?  Thanks!

    CommentAdd your comment...

    4 answers

    1.  
      3
      2
      1

      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?

        CommentAdd your comment...
      1.  
        1
        0
        -1

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

        Thank you!

          CommentAdd your comment...
        1.  
          1
          0
          -1

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

          Thank you!

            CommentAdd your comment...
          1.  
            1
            0
            -1

            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!

              CommentAdd your comment...