I’m not understanding how to tell Bubble how the data in different tables is related. I have a table for Products, a table for Variants and a table for Orders. [Shopify DB Relationships] In SQL terms there is a one to many relationship between Products & Variants and a one to many between Varian…

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 dif…

Its super simple. I can guide you how databases works in bubble. Lets discuss on call.

To add to George’s great reply (FYI, George, I use literally the same naming convention in my apps, which might make you want to change yours for one reason or another :wink: )… and you might already know this, but it’s not clear to me from your post… the only thing defining the primary display fiel…

Thanks for the reply. So I have now added a field called Variants in my Product DB table and set it as a type ‘List of Variants’ (a single product has multiple variants). But still no joy on the frontend. [Screenshot 2023-09-09 at 13.30.32] Do I actually need to populate that new ‘List of Varian…

I did not know that, so thanks for clarifying. I assumed it was how you specified the keys.

[image] wrightj2: Do I actually need to populate that new ‘List of Variants’ field with a list of variant IDs? You don’t need to populate it with the IDs themselves, but you do need to populate it with the variant things that are associated with each product. You could also have a product fie…

To be explicit (because this also comes up a lot) Let’s suppose you create a Shopify Variant in Step 1 and Shopify Product in Step 2. In Step 2, you want too add the Shopify Variant you created to the Variants list. In the expression composer, this looks like: Variants add Result of step 1 (i.e, t…

[image] mikeloc: FYI, George, I use literally the same naming convention in my apps, which might make you want to change yours for one reason or another :wink: Maybe I picked it up from you somewhere in the forum :laughing:

Confused - How to create relationship between tables in database

Need help Database

georgecollier September 9, 2023, 1:06pm 9

Maybe I picked it up from you somewhere in the forum

1 Like

Topic		Replies	Views
Relational Database Questions	13	4367	September 4, 2019
Setting up Data Relationships Database	5	518	January 24, 2024
Data Model Suggestions Database	3	1795	May 8, 2017
How to setup two fields are primary key in same table Database	6	3015	October 25, 2022
Please Help Me Understand How Bubble Manages Relationship? Need help	7	2330	September 1, 2018

Confused - How to create relationship between tables in database

Related topics