I can not setup basic relationships between two budibase db tables #15848
-
|
Hi, I am trying out Budibase (as a service) for an internal tool, I am a 20+ yrs web dev, I have setup databases countless times, but I can not setup a simple O2M relationship... I have tried following the docs that state (https://docs.budibase.com/docs/relationships) The "Use as table display flag" is not present in the field creation form when I try to do that I tried every way, when I choose 'relationship' for a new column field type I run into all kinds of errors... Could anyone tell me how to do something so basic? Thank you |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
Hey @smarques - once you've create a column you're able to set it as a display column. It's a slight change in UI that hasn't been updated in the documentation. (I'll do that next)
Provided both tables have columns, you should be able to add a column to either table - Budibase does not support one-to-one relationships, so if you can't find the "one row" option, switch the other table's setup to "many rows" |
Beta Was this translation helpful? Give feedback.
-
|
I see, thank you very much! |
Beta Was this translation helpful? Give feedback.
Hey @smarques - once you've create a column you're able to set it as a display column. It's a slight change in UI that hasn't been updated in the documentation. (I'll do that next)
Provided both tables have columns, you should be able to add a column to either table -
Budibase does not support one-to-one relationships, so if you can't find the "one row" option, switch the other table's setup to "many rows"