Title: Referee and event database setup help
Last modified: March 10, 2025

---

# Referee and event database setup help

 *  Resolved [bencsikzoli85](https://wordpress.org/support/users/bencsikzoli85/)
 * (@bencsikzoli85)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/)
 * 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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18354444)
 * Hi [@bencsikzoli85](https://wordpress.org/support/users/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](https://wpdataaccess.com/docs/app-form-builder/app-lookups/)
 * You can then choose to enable [inline editing](https://wpdataaccess.com/docs/columns/column-actions/)
   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](https://wordpress.org/support/users/bencsikzoli85/)
 * (@bencsikzoli85)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18359250)
 * Hello, what type the referee column in the event table should be?
 *  Plugin Contributor [Kim L](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18360450)
 * Hi [@bencsikzoli85](https://wordpress.org/support/users/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](https://wordpress.org/support/users/bencsikzoli85/)
 * (@bencsikzoli85)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18361470)
 * Hi [@kimmyx](https://wordpress.org/support/users/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](https://wordpress.org/support/users/kimmyx/)
 * (@kimmyx)
 * [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18364786)
 * Hi [@bencsikzoli85](https://wordpress.org/support/users/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](https://wpdataaccess.com/contact/)
   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.

 * ![](https://ps.w.org/wp-data-access/assets/icon-256x256.png?rev=3299063)
 * [WP Data Access – App Builder for Tables, Forms, Charts, Maps & Dashboards](https://wordpress.org/plugins/wp-data-access/)
 * [Support Threads](https://wordpress.org/support/plugin/wp-data-access/)
 * [Active Topics](https://wordpress.org/support/plugin/wp-data-access/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wp-data-access/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wp-data-access/reviews/)

 * 5 replies
 * 2 participants
 * Last reply from: [Kim L](https://wordpress.org/support/users/kimmyx/)
 * Last activity: [1 year, 1 month ago](https://wordpress.org/support/topic/referee-and-event-database-setup-help/#post-18364786)
 * Status: resolved