Forum Discussion

TaoufikBeghdadi's avatar
TaoufikBeghdadi
Qrew Member
5 years ago

Import columns to a new Table

Hello All, 
I would like to import 2 columns from one table to another table under the same app. I tried to use table to table relationship, but it did not work.
Any suggestions, please 🙏

------------------------------
TK
------------------------------
  • PaulPeterson1's avatar
    PaulPeterson1
    Qrew Assistant Captain
    Can you provide a little more information?  Please describe the relationship (which is parent and which is child) and what you have done so far.

    ------------------------------
    Paul Peterson
    ------------------------------
    • TaoufikBeghdadi's avatar
      TaoufikBeghdadi
      Qrew Member
      I did not establish a relationship between the two tables yet. Both tables contain invoicing data, and I want to find a way to compare between the billing amounts in the two tables, and highlight discrepancies.

      ------------------------------
      Taoufik Beggdadi
      ------------------------------
      • PaulPeterson1's avatar
        PaulPeterson1
        Qrew Assistant Captain
        I would create a relationship between the two tables, create lookup fields for the two columns you want to compare, then you could compare the lookup values from the parent table to the values in the child table

        ------------------------------
        Paul Peterson
        ------------------------------