I’m struggling to understand how to get data based on relationships I have set up in my database tables. I’m specifically referring to using dynamic expressions to get the data. I’m going to use standard language as I’m still learning to move over to Bubble’s terminology. In your response, please feel free to use Bubble terminology and use old terminology where you think it would add clarity.
How would I type a dynamic expression to get to the following:
- The score in the record in the Scores Table circled in red and thus the value of 9.8. (Typically in my SQL string WHERE statement I’d say WHERE ProjectID = 1, Topic = 1)
- The Category name of Sport. (Typically in my SQL string WHERE statement I’d say WHERE CategoryID = 1)
Below is an example of a database structure.