Hello, this is my first steps in Five. In the tutorial video “How to Create a Many-to-Many Relationship in Five”, there is a panel called “relationship” with a plus sign in order to add new relations. In my application, I don’t have such panel, just a tab called “References” but no plus sign. Looks like an incomplete feature in a new version? How can I add new references like in the video? Thanks.
Hi Jean,
I am not sure why you do not see the button to add relationships, I reckon you might accidentally be under the “Tables” Menu instead of “Table Wizard”. If that’s not the case can you upload a screenshot of what you are seeing?
You are right, I was not under the table wizard. I start creating a table with the wizard this time and I can effectively now add a relationship. Many thanks!
1 Like
How can a relationship be created without using “Table Wizard”? i.e. How can I create a relationship for an existing table?
Hi BabaJahi,
That can be done through the “Tables” menu,
-
Click on "Data and then “Tables”
-
It should show you a list of all your existing tables, click on one(make sure this table has a field for Foreign Key as Five will not generate the primary and foreign keys for existing tables)
-
Now, go to the “Indices” menu and click on add Indices which is shown by a “+” Icon.
-
In the “Indices Menu”, select “Foreign” as the key type and complete the necessary details such as Dependent Index, Foreign Key Table, etc.
-
Finally, click on “Index Fields” and select the field from your current table that corresponds to your Foreign Key.
