Referee and event database setup help

  • Resolved bencsikzoli85

    (@bencsikzoli85)


    1 year, 1 month ago

    Hi,

    I’d like to create the following app. I have a referee table and an event table.

    I want to create an app somehow where I can add (assign) the referees to events).

    What kind of additional table do I need to create a many:many relation and how can I do the form or anything else where I can select which referee were acting at the selected event (competition)?

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

    (@kimmyx)

    1 year, 1 month ago

    Hi @bencsikzoli85,

    Thanks for the post!

    Do you already have a referee column on your event table? If yes, you can simply create a data admin app for your event table, then assign a lookup to your referee column.

    Learn more about adding lookups here: Lookups | WP Data Access

    You can then choose to enable inline editing for your referee column and then choose the referees for each event there.

    Hope this helps! Let us know if you have other questions.

    Thread Starter bencsikzoli85

    (@bencsikzoli85)

    1 year, 1 month ago

    Hello, what type the referee column in the event table should be?

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 1 month ago

    Hi @bencsikzoli85,

    If you intend to use the referee table as a lookup table, it’s best to refer to it via its ID column from your events table, so a numerical type column would work.

    Hope that helps! Let us know if you have other questions.

    Thread Starter bencsikzoli85

    (@bencsikzoli85)

    1 year, 1 month ago

    Hi @kimmyx

    It almost works. I’m able to select 1 referee, but I would need to select more. So between the events and referees there should be a many:many connection. Also it would be good to list the events where the referee acted on the referee detailed view.

    Plugin Contributor Kim L

    (@kimmyx)

    1 year, 1 month ago

    Hi @bencsikzoli85,

    Thanks for the response.

    Could you send us a screenshot of your current set up now?

    You can send us a message via Contact | WP Data Access if you want to share more information privately.

    We’ll wait for your response!

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

The topic ‘Referee and event database setup help’ is closed to new replies.