How to link tables data

Using Project tracker template. I removed task table and using Project table & Client table. When I add in new Client, it is not reflected in Project table. Pls advise. Thank you.

To establish a link between records between tables, you need a column of type “link to other records”. When you add such a column in one table, SeaTable creates the corresponding table in the linked table automatically.

Once this is done, you can link records. Click in a cell in either link column. A wizard shows you all linkable options in the linked table. Select one by clicking. Voilà.

By modifying the settings, you can modify the displayed value in the link column. Similarly, you can also specify if you want a 1:1, 1:n or n:m relationship between the tables.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.