Get information from DB after selcting one option
I'm trying to make myself a place to record all my tests results (from a sport).
Let's say i've just finished a strength test.
Scenario:
I have one table with what kind of tests i do. (for example: Bench press, pull down etc).
and one table to register my results
The db structure is:
table name: tests
- id
- name
- exercises (json, populate through repeater field. properties in this json is: Name and Type)
table name: test-results
- id
- date
- test
I'm not sure how to set up the test-result table, but what i'm trying to do now is to choose the kind of test i'm taking, and then put in the results from my test where it gets data i need to record from the table tests.
i'm not sure if i'm clear enough, just ask and i'll try to answer.
2 Replies
Okay I get what you want to do, what is your question? I don't know where to help you if you just say "I'm not sure how to set up the test-result table", can you be a bit more specific about what your problem is?
You probably want a select with a relationship for your test and then a keyvalue or similar that’s prepopulated with your tests exercised and stores to another json column?