I created two tables to test this. test tutor and test student. My goal is to have use a select box to allow for selection of a student on the tutor record. I created tables using the "Create a data table by importing data from a data source." option to create the tables. In test tutor I have fields called student 1, student 2, etc. I made these fields this way (see a1.png). If I go to edit the contents, the "student 1" column does not show up. I am attaching the csv's for both tables also. I then added a filter to that same "student 1" like this: (see a2.png). I still do not see the "student 1" field. "student 2" is doing the same thing. I did not try on student 3 and 4. Can you help me please?
I created two tables to test this. test tutor and test student. My goal is to have use a select box to allow for selection of a student on the tutor record. I created tables using the "Create a data table by importing data from a data source." option to create the tables. In test tutor I have fields called student 1, student 2, etc. I made these fields this way (see a1.png). If I go to edit the contents, the "student 1" column does not show up. I am attaching the csv's for both tables also. I then added a filter to that same "student 1" like this: (see a2.png). I still do not see the "student 1" field. "student 2" is doing the same thing. I did not try on student 3 and 4. Can you help me please?
Attached files: a1.png
test-student.csv
test-tutor.csv
a2.png