Need help on relationships between bases

bubbleweb5151 · 2024-12-01T17:49:01.754Z

hello everyone, I’m french so excuse me for the translation

i don’t understand the mechanism of relationship between 2 bases with bubble.

i made a very basic example to make myself understood

I created a new database called “cars” with a single entry “name”

and in my user database, I created a relationship with the cars table by creating an entry of type cars

I created a single user, I connected with the help of “run as”

using an input + a button to validate, I created a car called “mercedes”

everything worked well for the creation and we can see the email of my user appearing as creator

my problem is that I can’t display the name of this car in the visual text element

cars1334×630 128 KB

normally it should work but nothing is displayed

empty1366×637 53.7 KB

this tells me that the field is empty, but it does exist in my database

and I am connected with the only user I created

user1366×768 128 KB

seul user1366×768 134 KB

could you help me understand please

relation1366×635 92.1 KB

because I think I have understood the relationship between the user table and cars

but it doesn’t work

thanks in advance for your help

krenkel · 2024-12-01T20:39:11.428Z

Hello, @bubbleweb5151! I did a test here by creating a car table, with two fields, as I will send you some prints. I believe you have reversed it, because the car has a customer, because the customer registration comes before any purchase of a car, right, or of any product, because the product needs to have someone for it to be linked to something or someone. In my opinion of course, I am just a mere beginner too. I will send you the prints. You need to work with nested reapeat groups.

carr185×137 2.38 KB

tb_carro400×312 13.1 KB

tb_user715×326 20.3 KB

bubbleweb5151 · 2024-12-02T22:05:35.852Z

Thank you very much for your answer

geesonofgee · 2024-12-03T12:50:14.897Z

bubbleweb5151:

seul user1366×768 134 KB

seul user1366×768 134 KB

U’re almost there, from this image “car” is also empty, I think u’re making the wrong call,
Yes have the relationship set-up well but you have to make it work via a workflow “Make changes to current user”
By so doing u’ll have the the relationship working well…

if you’re not clear with my explanation, I can give you a free 15min call so we can both sort it out