Title: Reference other groups/foreign keys/fields
Last modified: March 2, 2022

---

# Reference other groups/foreign keys/fields

 *  [netzwerkstatt](https://wordpress.org/support/users/netzwerkstatt/)
 * (@netzwerkstatt)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/reference-other-groups-foreign-keys-fields/)
 * Hi, and first off: big thanks for providing your free plugin, the clean interface
   and the ton of documentation!
 * However, I couldn’t find anything on your website or in the forum so here it 
   goes: is it possible to reference a field to another field from a different group?(
   Example below)
 * I’m aiming at building a website to handle different kind of data, basically 
   people submit data to a form, the data is stored in the db, they can change it
   and after some time generate some nice charts.
 * Example: I’m setting up a new group to store “states” (with a “title”-field like
   California, Texas, …).
    Now, I’m creating a new group to store “organisations”
   and every organisation should have a field “state”. The possible values for this
   field should come from the group “states” and its “title” (or ID) field. So I’m
   looking for a drpodown-fieldtype, that gets its values from a different field.
   To go further: I also have particpants/users and need every organisation to have
   a user (1:n relationship), is that possible with your plugin? Do I maybe need
   an addon?
 * So basically I’m for a plugin which allows me to create forms, cross-reference
   them, store the data and add some logical “programming code” to all that.
 * Thanks in advance!

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

 *  Thread Starter [netzwerkstatt](https://wordpress.org/support/users/netzwerkstatt/)
 * (@netzwerkstatt)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/reference-other-groups-foreign-keys-fields/#post-15419626)
 * Maybe this could do the trick? [https://gist.github.com/xnau/98bbfd267ff98e912937c03abc806937](https://gist.github.com/xnau/98bbfd267ff98e912937c03abc806937)
 * I guess I got it wrong, I thought adding a new group is like adding a new entity/
   table. Is that possible? I need users/participants assignend to one or more organisations.
   The users should be able to fill out a form for each of their organisations and
   that submitted data should also be stored in the database.
 * /e: can I add new “entities” with custom templates? [https://xnau.com/work/wordpress-plugins/participants-database/participants-database-documentation/pdb-templates/](https://xnau.com/work/wordpress-plugins/participants-database/participants-database-documentation/pdb-templates/)
   /
   e2: nevermind that …
    -  This reply was modified 4 years, 2 months ago by [netzwerkstatt](https://wordpress.org/support/users/netzwerkstatt/).
    -  This reply was modified 4 years, 2 months ago by [netzwerkstatt](https://wordpress.org/support/users/netzwerkstatt/).
 *  Plugin Author [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [4 years, 2 months ago](https://wordpress.org/support/topic/reference-other-groups-foreign-keys-fields/#post-15419934)
 * OK, so I don’t know if what you’re asking about is possible. Maybe…you will need
   to have some pretty good coding skills to make it work smoothly.
 * It is possible to treat the field groups as separate databases, but there will
   be limitations because they are not really separate.
 * [“Multiple Databases” with Participants Database](https://xnau.com/multiple-databases-with-participants-database/)
 * Another possibility is this add-on: [Participant Log](https://xnau.com/product/participant-log/)

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

The topic ‘Reference other groups/foreign keys/fields’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

## Tags

 * [dropdown](https://wordpress.org/support/topic-tag/dropdown/)
 * [field](https://wordpress.org/support/topic-tag/field/)
 * [foreign](https://wordpress.org/support/topic-tag/foreign/)

 * 2 replies
 * 2 participants
 * Last reply from: [xnau webdesign](https://wordpress.org/support/users/xnau/)
 * Last activity: [4 years, 2 months ago](https://wordpress.org/support/topic/reference-other-groups-foreign-keys-fields/#post-15419934)
 * Status: not resolved