Linking data types across the app

Need help Database
1

I have 4 objects (data types) that I want to link to each other but I am struggling to execute.

User
Account (each user is linked to ONE account)
Projects (each Account can have multiple Projects, Project can have only ONE Account)
Ads (each Project can have multiple Ads, ads a linked to only one Project)

Here are a few struggles I have:

When a user logs in, he creates an account and is linked to this account. This works.
When the user fills out a form to create a project. I cannot get this project linked to the User’s account

image
image678×1120 67.3 KB

In the same workflow, I am creating a new step where I want to update a field under the Account data type, to add the newly created project under.
This does not work either despite the workflow not showing any error.
image

image
image1552×814 71.2 KB

image
image1598×1494 216 KB

image
image1552×1196 95 KB

Thanks for your help

2

In your User datatype, the account is of type “text”.

I believe you store the unique id of the account, which is probably not you want to do.

In your Project objet, the account is of type “account”. So that’s on the first screen you cannot easily set the project related account as the current user’s account.

In your second screenshot, “make changes to account…”, you wouldn’t need to “do a search for” if the user relatated account was of the correct type. You would be abble to edit that account right away.

I believe all the difficulties you have come from this.

3

Thanks for your help but it seems I cannot sort out my issues. To be honest I’m struggling to understand how the database works. It seems super sophisticated and powerful but probably takes a bit of time to understand how it works. I will try to read more documentation

4

You’ve done things right on the “project” object → “related account” is an object and not just a text.

You need to modify your User object, delete the current field “account” which is text, and create a new one “account” of type “account”

Just like so
image

5

That’s what I have done but it still does not allow me to do find the account.

6

Thanks to your help and some more video tutorials and reading I have now a way better understanding of tables relationships in the DB. Thanks a lot