This is insanely straight forward and I can’t seem to get a straight answer anywhere that works. It’s a super simple request.
I’m giving a hypothetical sample to keep this super simple.
Imagine Table A has one record with one field labeled Color and one field labeled HEX. In that one record for the field color the word Red appears and in the HEX field the text #FF0000 appears .
Imagine I have another Table B with many records. One of the fields is Color. I set that field up to link to Table A (cannot recall Bubbles terms for this but I do this exactly as shown in Bubble’s video).
Now imagine I just want to pull one record from Table A and I want to know what is in Field HEX (which is connected to Table A). Basically I want to see the result of #FF0000 . How in a dynamic query do I do that? I’ve tried a thousand times to add the constraint Color = Red and I’ve even done Color = The primary key number.
Nothing works. I’m beyond baffled there isn’t a video anywhere showing how to do this.
I’ve spent a lot of time learning Bubble (weeks) to get to this game stopping problem that doesn’t have a simple answer. What am I missing? This seems like a terrible oversight in the training videos because this is THE reason a relational database is so valuable.