Self-Referencing Table

biz.net-dev · 2024-09-25T10:19:11.343Z

I have a table where the field Account_Code is a code with up to 5 levels. The field Account's_Father is the parent of Account_Code, which makes reference to the field “Account_Code” of the same table.

image331×571 3.62 KB

I also have another table where the relationships between each code and its parent code are already defined, but they are not yet set up as self-referencing within the same table.

image336×598 4.5 KB

My question is how to automatically create these self-referencing relationships in the main table.

I do not want Account's_Father to reference the other table. What I want is for Account's_Father to reference the Account_Code field within the same table.

I already tried to get the unique_id from the Account_Code in the Fathers’s_Account and use the Modify Data through CSV but bubble seems to doesn’ understand that i’m making a reference to the same data type

How could I automate this process?

ps: the data type is “text”

tunacardak · 2024-09-25T11:31:16.543Z

What type of fields are they? Are they text?

biz.net-dev · 2024-09-25T21:07:54.489Z

Yep! They are text!