Can you use Subtables with Existing database?

Okay. I got it to wor! Yay. Finally - but not with subtables - I gave up on subtables! I just used the tutorial below again (I had the output selected for one part that I shouldn’t). Thanks very much for your help.

Its great to finally see nested repeats :slight_smile: Thanks very much guys - @guptast and @Sorry_Duh :slight_smile:

……
For the benefit of others :blush:….

I followed the tutorial below.

With respect to Subtables I am not sure why it didn’t work? Even though I could see the ‘subtable’ showing in ‘Query Builder’. (by the way the subtable wasn’t originally showing in Query Builder, even though I have the foreign key setup correctly in MySQL, likely because the Database schema wasn’t refreshed as @George mentioned in his reply further above, but it appeared later on - I think after I did the refresh).

When I tested the query in ‘Query Builder’ the output didn’t show the subtable records, hence the nested repeat on the app side wasn’t working. I tried a few times and ensure the query were correct and couldn’t get it to work.

Regardless I achieved the same results using the nested repeat in Server App using the tutorial mentioned above.

2 Likes