Relationships between tables

This support ticket is created 4 years ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun	Mon	Tue	Wed	Thu	Fri	Sat
-	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	9:00 – 12:00	-
-	13:00 – 18:00	13:00 – 18:00	13:00 – 18:00	14:00 – 18:00	13:00 – 18:00	-

Supporter timezone: America/Jamaica (GMT-05:00)

This topic contains 1 reply, has 2 voices.

Last updated by Shane 4 years ago.

Assisted by: Shane.

Author

Posts

August 31, 2021 at 7:27 pm #2156429

ursS

I have 2 tables in a database:

Table A: (Field 1, Field 2)
A1, R1
A2, R1
A3, R2
A4, R1
A5, R2

Table B: (Field 1, Field 2)
B1, R2
B2, R1
B3, R2
B4, R2
B5, R1

When I select with a combobox Filed 1 of Table A (eg. A3)
I need to show the records of Table B with the same Field 2 (eg. B1, B3, B4)

Is it possible?

August 31, 2021 at 8:28 pm #2156465

Shane

Supporter

Languages: English (English )

Timezone: America/Jamaica (GMT-05:00)

Hi Urs,

Thank you for getting in touch.

If these are custom tables then you will need to create a completely custom function with the database queries to perform the operation on the custom tables such as querying for the fields and performing the table joins to pull the appropriate data.

Unfortunately this is not something that our Toolset plugins can assist with as we assume that all data is store in the wp_posts and the wp_postmeta table.

Thanks,
Shane