Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

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

Jimstrange
in Relationships

Featured Replies

  • Newbies

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.

 

Woocommerce Table

 

ID post_id meta_key meta_value
1 1 Field 1 Value
2 1 Field 2 Value
3 1 Field 3 Value
4 2 Field 1 Value
5 2 Field 2 Value
6 2 Field 3 Value

 

New Table, which should populate existing Woocommerce Table

 

ID post_id Field 1 Field 2 Field 3
1 1 Value Value Value
2 2 Value Value Value

I hope this makes sense and any advice will be greatly appreciated :)

Create an account or sign in to comment

https://fmforums.com/topic/98946-can-you-link-together-field-name-field-from-one-table-to-two-fields-in-another-table/
Go to topic listing

Similar Content

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.