Complex Multi-thing Query

[tylerboodman]

Is:
-group_tags a list of texts? It should be a list of Chat groups
-members a list of texts? it should be a list of Users

Just checking first you have it set up the “Bubble way”

Confused - How to create relationship between tables in database

Primary keys / foreign keys don’t exist in Bubble really. Well, behind the scenes they obviously do, but Bubble treats it differently (and I think they do it quite well). You rarely need to use ‘ids’ in Bubble. The primary key of a Thing is it’s unique ID. But you don’t save that unique ID to a different thing to connect it, you just save the actual Thing. Yes, it sounds weird if you’re familiar with other DB structures. Let’s suppose you have data as follows: Product Variant On the Product…