Hello. Newbie here, still just getting the hang of things.
I have a Master Table and want to make Sub Tables based on it. One column in the Master Table is “Categories,” and the Sub Tables will be category-specific. I want each Sub Table to be automatically filled with the same data as the Master Table, but limited to a specific category.
Could you please point me in the direction of information on how to do this? Or advise on what to do? In the meantime, I’ll keep searching and reading.
Thanks once again for your kind response. You’re right - I am able to filter at the front end, but… let me try and explain my situation. (Sorry - it’s hard for a beginner to express clearly!)
The front end runs on a Helper table that pulls the next unanswered question from the Questions table. This is based on the question number column in the Questions table.
The quiz is set up so that you answer one question, then press the “Next Question” button and go to the next question. Again, this action is based on the question number column in the Questions table.
The “Next Question” action triggers the next unanswered question in the Questions table regardless of category, so when the front end view is filtered by category, if the next question is in a different category, the screen goes blank.
The reason I thought Sub Tables might be a good idea is because if I have category-specific Sub Tables, I can easily set up Helpers to pull from those Sub Tables based on what I already have. I mean, it’s probably not the most efficient method, but it’s something I could manage at my beginner level.