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