I am trying to do relations where one user belongs to a company (one to one) and one company has many users (one - to many), how can i make it such that in my company table i can have a column to reflect which users belong to which company via relations?
1 Like
Here’s I think how you can achieve that:
If you want to display which users are related to a company, make sure you have a relation column that connects the Row ID in the Company table to the Company ID stored in the User table.
Since one company can have many users, ensure that the “multiple match” option is enabled in the relation column settings.
Once the relation is established, you can use a lookup column to display specific information (e.g., names or emails) from the related users in each row of the Company table.
2 Likes