Same Column in Different Tables

Two answers:

(1) If your tables represent exactly the same objects, then it might be a good idea to stick to one single table. Why do you wish to have two separate tables?

(2) If really you wish to copy a table and you want the two tables to be in sync, here is how you can do it:

  • Create a destination table we’ll call Copy. The following happens in Copy.
  • Create auto-incrementing row indexes (Row ID → Lookup of Row ID column → Find index value of the lookup column). This will give you row indexes/row numbers, starting at 0, and it will increment with each new row.
  • Create a Single Value column configured as follows: From Start → RowIndex → Value you want to copy from the original table.

If the size of the original table is fixed, then you can do a right click on the table and duplicate it.

3 Likes