# Develop a Fantasy League webapp with Glide

**URL:** <https://community.glideapps.com/t/develop-a-fantasy-league-webapp-with-glide/72980>\
**Category:** Ask for Help\
**Created:** [May 1, 2024, 1:58pm UTC](https://community.glideapps.com/t/develop-a-fantasy-league-webapp-with-glide/72980 "2024-05-01T13:58:30Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![CarloA](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/carloa/32/74297_2.png) [@CarloA](https://community.glideapps.com/u/CarloA)\
**Post date:** [May 2, 2024, 10:45am UTC](https://community.glideapps.com/t/develop-a-fantasy-league-webapp-with-glide/72980/5 "2024-05-02T10:45:49Z")

</div>

Ty for the help.

Users participate in a “Crypto Fantasy League” by creating portfolios composed of crypto tokens.  
Users can view available tokens and use a buy/sell button for each token to open an edit screen.  
This screen includes a number entry field where they can specify the amount of tokens to buy or sell.  
Every submitted transaction creates a row in the “Orders” table (Glide Table) with details such as “User ID, Token ID, and Quantity Transacted” (as shown in the attached image).

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf24eeb1a82e92411fd5c2e16146ca2bd746ab89.jpeg)

My question is:  
**Is it possible, by creating a relationship between the “Orders” and “Users” tables, or in some other way, to have all the portfolio-related information in the “Users” table?**  
For example, if a user has made three transactions:

- Bought +10 tokens of A
- Bought +10 tokens of B
- Sold -5 tokens of A

I would like the “Users” table to reflect that the user owns 5 tokens of A and 10 tokens of B.

Thank you very much for your help!

---

_[View the full topic](https://community.glideapps.com/t/develop-a-fantasy-league-webapp-with-glide/72980)._