# Trouble defining my tables and their relationships

**URL:** <https://community.glideapps.com/t/trouble-defining-my-tables-and-their-relationships/68587>\
**Category:** Ask for Help\
**Created:** [December 12, 2023, 2:26am UTC](https://community.glideapps.com/t/trouble-defining-my-tables-and-their-relationships/68587 "2023-12-12T02:26:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Miguel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/miguel/32/62912_2.png) [@Miguel](https://community.glideapps.com/u/Miguel)\
**Post date:** [December 12, 2023, 2:26am UTC](https://community.glideapps.com/t/trouble-defining-my-tables-and-their-relationships/68587/1 "2023-12-12T02:26:01Z")

</div>

A little bit of context about the app:  
On a school students go and weight recyclable materials (Plastic, metal, etc…) and a helper registers the material, the weight and the student.  
The app will be used so these helpers can enter weights of materials for a specific student.

I’d like to have the following flow:

1- I look up a student and click on it, opening the details page  
2- I see a list displaying the materials on the database (Metals, Plastics, etc…)  
3- I select a material opening another details page  
4- Within that details page I see a list displaying previous entered weights for the material and their register dates.  
5- Within the same details page I have the button to enter a new weight by entering the weight in kilos and the register date.  
6- On submit, the register should go to the respective material category and to their respective student.

I’ve been giving it some thought but I can’t come up with solid table relationships.  
If this is not possible or there are easier ways to implement this I would really appreaciate new other approaches.  
Thanks a lot in advance.