How can I link two tables and query them via the UI?

Hello Bubble.io community

I need your help with an actually simple task.

Initial situation: I have 2 tables Table A & Table B
In Table A I would like to have a book title and in Table B the chapters.

Now my problem is. I would like the user to enter a book title via the UI which is saved in Table A. The corresponding chapters should be saved in Table B. How can I link the book title with the corresponding chapters, i.e. Table A (Title) with Table B (Chapters) and that each additional chapter added is linked to the corresponding title without having to enter the title each time.

Then I would like to be able to call up a book title and all the associated chapters should be displayed.

I hope I was able to express this clearly.

Translated with DeepL.com (free version)

Hey! In this case, you can add a field to Table B—something like “Parent Title”—to create a connection between the two tables. Then, on the page, you can set up a Repeating Group using Table A as the data source to show all the titles. Inside each cell of that RG, you can add a second Repeating Group with Table B as the data source, using a constraint where the parent is the current cell’s title. You can also include an input inside the first RG cell to add a new chapter, setting its parent to the current cell’s title.

Hi Rafael
Thank you for your feedback.
I don’t quite understand how the linking of the tables works if I want to do this outside of the table editor. So via webgui of the frontend.
I have understood that I can make the link “Data > App Data > Modify”, but I would like this to work via the frontend. Is this even possible?

For example: The user writes another chapter. The chapter should then be automatically assigned to title 1 from table A on the page. I hope I was able to get this across clearly.