Help please: Is it possible to link tables?

Hey guys,
I’m a beginner here needing a bit of help. In this project I’m trying to link a table that has the title of Question Sets (table 2), to a table that has the questions (table 1).
I would have preferred having a single table, with the name of the questionset being the column, but I haven’t been able to display the column titles in a list view. So I thought I would do it this way instead.
The only way i’ve been able to link them is by saying IF questionset1 is selected, then list the questions from Table1:Column1. IF questionset2 is selected, then list the questions from Table1:Column2.
This is going to be a problem if i try to scale this to more question sets.

Is there a more elegant way to solve this issue?
Is there a way to have it one table, and get the list view to display the column entries?
If not, is there a way to link these tables so that row1 from table2 corresponds to column1 from table1, and row2 from table2 corresponds to column2 from table1

Thanks in advance


I was able to solve this by setting up the table this way instead

Glad you got this to work!

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.