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.
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.
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”