# Hunting event (Sport event) **URL:** \ **Category:** Ask for Help\ **Created:** [November 22, 2021, 1:53pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906 "2021-11-22T13:53:19Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![one.on.fire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/one.on.fire/32/34946_2.png) [@one.on.fire](https://community.glideapps.com/u/one.on.fire)\ **Post date:** [November 22, 2021, 1:53pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/1 "2021-11-22T13:53:19Z")
Hi! I want to make an app for our hunting team. The background is that we want some statistics, participation and animal killed. For each hunting event, there can be one or several animal killed, or non… My design is that I have one table/sheet for all events (date, participated) and one table for hunted animal (shooter, species and so on). What I dont seem to find is the relation between those tables? Because there is no static entity between them to relate to. Both are event that are made and you cant in advance know, I.e how do Glide know that this Shooting are related to a certain Event? It´s the same problem if you thing of a sport event. You have a match in one table and the goal in a other table. How do you match them? The goal is not to make up the event and then add the animal hunted, I want to do it at the same time (or at least that thats whats happing for the user). Pls help! (I cant sleep 🙂 ) /J ---
**Author:** ![one.on.fire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/one.on.fire/32/34946_2.png) [@one.on.fire](https://community.glideapps.com/u/one.on.fire)\ **Post date:** [November 22, 2021, 2:00pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/2 "2021-11-22T14:00:42Z")
In this example the match in “match\_mast” has i “match\_no” that same value is also in the table for “goal\_detalis”, and thats the key for finding (relate) each other. Is there any way I can do this i Glide? [https://www.w3resource.com/sql-exercises/soccer-database-exercise/soccer-database-image.php](https://www.w3resource.com/sql-exercises/soccer-database-exercise/soccer-database-image.php) /J ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 22, 2021, 2:26pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/3 "2021-11-22T14:26:33Z")
Of course through relation table, what i mean is that is possible. Since you are new I suppose you want to know only the potentially of Glide. Then, don’t worry, you can cover the whole db with this app ---
**Author:** ![one.on.fire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/one.on.fire/32/34946_2.png) [@one.on.fire](https://community.glideapps.com/u/one.on.fire)\ **Post date:** [November 22, 2021, 2:54pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/4 "2021-11-22T14:54:34Z")
Sounds good and thx for the answer! I have looked into the documentation, and maybe I dont understand, but can you pls give me some directions or examples how to move or copy a vaule from one table to another? Can this be done by some script or by the standard components in Glide? Br J ---
**Author:** ![MIKAHEL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikahel/32/25039_2.png) [@MIKAHEL](https://community.glideapps.com/u/MIKAHEL)\ **Post date:** [November 22, 2021, 8:17pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/5 "2021-11-22T20:17:52Z")
Standard component. They are events to do that. With buttons or after you submit a save of data But you may compensate something via the Googlescripts ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 22, 2021, 11:48pm UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/6 "2021-11-22T23:48:32Z")
> [@one.on.fire](#): > > What I dont seem to find is the relation between those tables? Because there is no static entity between them to relate to. Sounds like in your Event table you need a rowID column, then in your Hunted Animal table you should have an “EventID” column so you can relate the event to the hunted animals (multiple relation). ---
**Author:** ![one.on.fire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/one.on.fire/32/34946_2.png) [@one.on.fire](https://community.glideapps.com/u/one.on.fire)\ **Post date:** [November 23, 2021, 9:32am UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/7 "2021-11-23T09:32:19Z")
Thank you ThinhDinh! Exactly my thought also but how do I get the value in rowID in Event to the “EventID”? Pls help me! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 23, 2021, 9:53am UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/8 "2021-11-23T09:53:33Z")
How are you adding the hunted animals? If you use a form in the app, you can use the special value “rowID” from the event screen to pass it to the Hunted Animals table. ---
**Author:** ![one.on.fire](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/one.on.fire/32/34946_2.png) [@one.on.fire](https://community.glideapps.com/u/one.on.fire)\ **Post date:** [November 23, 2021, 11:24am UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/9 "2021-11-23T11:24:28Z")
Thanks! I will try to see how I can manage the “pass it” transaction in the form component then. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 23, 2021, 11:32am UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/10 "2021-11-23T11:32:48Z")
> **[Screen Values](https://docs.glideapps.com/all/reference/values/screen-values)** Here’s a documentation for you. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 24, 2021, 11:33am UTC](https://community.glideapps.com/t/hunting-event-sport-event/34906/11 "2021-11-24T11:33:19Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.