0 Replies Latest reply on Jan 22, 2016 9:17 AM by Strangeyboy

    Can you link together Field name + field from one table to two fields in another table

    Strangeyboy

      I am working with a Woocommerce installation and trying to create a product form interface. Woocommerce stores product attributes as meta_key's and values. I was wondering if there was a way of linking the table to a different table which would be more manageable and easier to use.

       

      Below I have tried to illustrate the two different tables and was wondering if there was a way of linking them together allowing them both to update when information is entered. I have a feeling I might need to use global fields and calculations. However, not completely sure if it is possible. Any advice will be greatly appreciated

       

      Woocommerce Table

       

      IDpost_idmeta_keymeta_value
      11Field 1Value
      21Field 2Value
      31Field 3Value
      42Field 1Value
      52Field 2Value
      62Field 3Value

       

      New Table, which should populate existing Woocommerce Table

       

      IDpost_idField 1Field 2Field 3
      11ValueValueValue
      22ValueValueValue