AnsweredAssumed Answered

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

Question asked by Strangeyboy on Jan 22, 2016

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

Outcomes