Tables relationships Version 5.2

Hi Nuno,

Can you share your table structure? Maybe we can help set up your first relationship?

You can find the documentation about relationships here:
https://wpdataaccess.com/docs/app-form-builder/app-relationships/

The relationship wizard contains inline help for each step as well.

Best regards,
Peter

Hi Peter,
Thank you for your help,

The doc link sent seems to be related to a newer version of WP DATA ACCESS, can’t find it on the 5.2 version.

I need a pretty simple relationship between 2 tables on the same DB, wp_posts and wp_postmeta.
From wp_post i need the ID column and post tiltle.
From wp_postmeta i need the post ID and then the post type column with value chbs_price_rule where the fields equals: chbs_price_1, chbs_price_2,chbs_price_3

post ID from wp_postmeta table is related to the ID column on wp_post table
I want to have this data on a simple form that i can then update fields values.

*I have been able to create a table with that data using the custom post type option on the Premium Data Publisher option but can’t do it when creating a form and from a table i am not able to update values.

I am sure that is simple to achieve but i am a bit lost looking around.

Thanks!
NunoS

• This reply was modified 1 week, 2 days ago by nunosilva85.
• This reply was modified 1 week, 2 days ago by nunosilva85.

Hi @nunosilva85,

Thanks for the response.

Premium Data Publisher is a legacy tool and will be removed soon next year. Unfortunately, we won’t be able to assist with issues arising from using the old tools as our resources are now reserved for the support and development of new features.

We urge you to try out the newest tool, App Builder, and test the relationship feature Peter previously linked. The new App Builder is more intuitive and user-friendly than the legacy tools. ??

Let us know if you have more questions. ??