Relational DB with GUI

  • devcom5155

    (@devcom5155)


    1 month ago

    Good day

    I am wanting to create a GUI of a relational database to track payments for markets.

    Table 1 contains the market details and table 2 contains the payments made for those markets.

    On the GUI, the users must be able to select the Market and then all payments for that market must be displayed next to it.

    The user must also be able to add new markets and new payments.

    I have searched the list of plugins and for methods of doing this, but all i find is “Forms” and have tried a few of them, but cannot find the method of doing what I need.

    This is for a new startup, and so funds are limited, and am unable to make use of any paid plugins.

    Any advice or suggestions will be welcomed.

    Thank you

    David

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • fatiima

    (@fatiima)

    1 month ago

    Hi David,

    What you’re trying to build is more like a simple database app rather than a standard form setup. Most free form plugins won’t fully handle relational data (like linking markets with payments) out of the box.

    You could try using plugins like Custom Post Types + Custom Fields (for example, create “Markets” and “Payments” as separate post types and link them using a relationship field). Some free tools like ACF (limited) or Pods can help with this.

    Alternatively, if you’re comfortable with a bit of coding, creating a custom solution using custom tables or post meta might give you more flexibility.

    Hope this points you in the right direction

    Scott Kingsley Clark

    (@sc0ttkclark)

    1 month ago

    You might also look at this comparison sheet that shows many options out there are available to you.

    https://comparewp.org/cck

    It lists every current (and some past) plugin that does content types and custom fields. You would look for the plugins that have custom table support.

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.