join data from multiple tables

  • Resolved sandrom1

    (@sandrom1)


    1 year, 4 months ago

    Hello,
    I’m a newbie with this module and can’t figure out how to display data from multiple tables. I try to explain my problem:
    I have 2 tables:
    customers [code, surname, name]
    articles [codart,description]
    I would like to create a form to upload warehouse movements and I would like the surname to be displayed to me when I choose the customer code and the description to be displayed when I choose the item.
    Unfortunately I can’t find how to do this

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    1 year, 4 months ago

    Hi @sandrom1,

    Are you looking to create a publication using joined tables?

    You can do so by creating a publication using a custom query, however, this is a premium feature. More information here: Custom Queries

    Could you tell us more about the form you’re looking to create? You mentioned upload; do you mean to upload a file?

    We’d love to know more. 🙂 We’ll wait for your reply.

    Thread Starter sandrom1

    (@sandrom1)

    1 year, 4 months ago

    Hi Kim,
    thanks for your quick response.
    we activated the premium version of the plugin just this morning, having understood that it could be useful. Now I will try to follow your instructions.
    I apologize for my english… I don’t have to upload files but I meant inserting information.

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 4 months ago

    Hi @sandrom1,

    Thanks for the response and clarification!

    We’re excited for you to learn more about WPDA’s premium features. 😀

    Feel free to browse our documentation and send us a message if you have new questions!

    For questions regarding a premium feature, kindly send us a message here: https://wpdataaccess.com/contactform/

    Or by clicking on the Premium Support icon in the WP Data Access dashboard.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘join data from multiple tables’ is closed to new replies.