Title: Table relationship
Last modified: April 6, 2020

---

# Table relationship

 *  Resolved [epi82](https://wordpress.org/support/users/epi82/)
 * (@epi82)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/table-relationship/)
 * Hello,
    I’d like to migrate my product into TablePress. You can see it here: 
   [http://funghi.funghiitaliani.it/](http://funghi.funghiitaliani.it/)
 * This plugin works with a single table? Is it possible to import more than one
   and then define a relationship?
    For example for combos or other info displayed
   in main grid.
 * Thank you very much.

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/table-relationship/#post-12637103)
 * Hi,
 * thanks for your post, and sorry for the trouble.
 * It is possible to have more than one table in TablePress, also from imports, 
   yes.
 * However, it is not possible to define automatic relationship (or JOINs in SQL)
   or something like that, as TablePress is not a database system but can only show
   static tabular data.
 * Regards,
    Tobias
 *  Thread Starter [epi82](https://wordpress.org/support/users/epi82/)
 * (@epi82)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/table-relationship/#post-12638321)
 * Thank you very much for your reply.
 * Other two answers:
    1- in frontend table view is it possible to hide columns?
   In demo examples I saw only filter and order options.
 * 2- in backend if I have to replace a value for a column is there any functionality
   to replace it for all rows or I have to do it one by one for each row?
 * Thank you in advance.
 * Elia
 *  Plugin Author [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * (@tobiasbg)
 * [6 years, 2 months ago](https://wordpress.org/support/topic/table-relationship/#post-12638764)
 * Hi,
 * 1) Yes, you can hide columns, via the “colvis” feature of the TablePress DataTables
   Buttons Extension from [https://tablepress.org/extensions/datatables-buttons/](https://tablepress.org/extensions/datatables-buttons/)
 * 2) No, sorry, there’s no such feature at this time. You’d have to do it one by
   one, or export the table to a CSV file, open that in e.g. Excel or a text editor
   and to the replacement there, and then re-import the CSV file, choosing to replace
   the existing table.
 * Regards,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Table relationship’ is closed to new replies.

 * ![](https://ps.w.org/tablepress/assets/icon.svg?rev=3192944)
 * [TablePress - Tables in WordPress made easy](https://wordpress.org/plugins/tablepress/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/tablepress/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/tablepress/)
 * [Active Topics](https://wordpress.org/support/plugin/tablepress/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/tablepress/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/tablepress/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Tobias Bäthge](https://wordpress.org/support/users/tobiasbg/)
 * Last activity: [6 years, 2 months ago](https://wordpress.org/support/topic/table-relationship/#post-12638764)
 * Status: resolved