If you want to link data from one table to another in Tabidoo, you can simply do it via field type Link to table as it is explained in the previous 5. chapter - Field Types in a Table.
Where to find the Type of binding in Tabidoo
In the advanced features, you can select ways how to connect the data between those tables. When the option Type of binding is opened, there are 4 ways of linking:
In this option, the data from the 1. table (e.g. Contacts) may be linked to many elements of the 2. table (e.g. Communication), but a member of the 2. table (e.g. Communication) is linked to only one element in the 1. table (e.g. Contacts).
Let's imagine you have two tables in Tabidoo - e.g. Contacts - where you keep all the information of your customers and the other one e.g. Communication - where you record all the conversation with these customers. You want to have an overview so when you open a specific contact in the table "Contacts", you see all the conversation that has been kept so far with the customer.
How can you do that?
How to setup binding One To Many in Tabidoo
What will happen now?
If you now edit or add a new record in the table, in the form displays the linked table. In this case, it means that you can see each conversation you kept so far with the customer. Moreover, you are able to directly add new data from this table into the linked table, so it saves you time and keeps your data organized.
Type of binding One To Many in Tabidoo
If in step 2. you selected any specific fields to be linked from the source table, they will appear in a grid of the current table.
If in step 3. you decided to show the field in the linked table, it will now appear in the grid of the linked table and you can as well select there if you want only this one or more fields to emerge.
In this option, the data from the 1. table (e.g. Communication) is linked to only one element from the 2. table (e.g. Contacts), but a member of the 2. table (e.g. Contacts) may be linked to many elements of the 1. table (e.g. Communication).
This type of binding you use when you simply want to link your records with one field from the other table and show it in a grid of your current table. You achieve it the exact way as we explained in the previous type of binging with only one slight difference and that is that in step 3 you select the type of binding - Many To One.
When you edit or add a new record, you can open a lookup by clicking on the link to table field in your form. From the lookup you can select any record to be linked. The linked records will followingly display in the table grid. If you want to set up which columns or records will be displayed in the lookup, visit How to define which data will display in the lookup.
The lookup in Tabidoo
This type of binging is used the most frequently, for that reason it is automatically preset for a user.
By selecting this option the data from the 1. table (e.g. Projects) will be linked to many elements of the 2. table (e.g. Staff) and the other way round.
Let's imagine you have one table "Projects" and the other one "Staff" where you keep all the info about your employees. You want to link those tables so that once you add a new project to your table, you can directly select which staff will be responsible for it.
This type of binding is also used in the extension User and Roles. It is therefore helpful, once you want to assign each of your users/staff roles depending on what you want them to access in Tabidoo.
How can you do that?
How to set up the binding Many to Many in Tabidoo
What will happen now?
The newly made field will appear now in a grid and moreover, you can see the linked table directly in the form. You are able to choose from all your staff which appears on the left side table, the ones, which will be responsible for this project by moving them to the table on the right side.
The binding "Many to Many" can be displayed by two different views.
In the advanced features you can set up the following component types:
Link the records easily by clicking at the left checkbox.
Link the records by moving them from left to the right table.
In this option the data from the 1. table (e.g.: Projects) may only be linked to one element of the 2. table (e.g. Staff) and the other way round.
We will follow the previous example with one difference. Let's imagine you want to assign a project to only one of your staff and you want to make sure, that the same project is not assigned at the same time to anyone else. Then this type of binding will be useful.
In other words, records can be linked just once in this type of binding. If you link twice the same field, the alert will show up.
An example of alert in Tabidoo after linking twice the same record