# Get data

**URL:** <https://community.glideapps.com/t/get-data/75946>\
**Category:** Ask for Help\
**Created:** [August 28, 2024, 12:48pm UTC](https://community.glideapps.com/t/get-data/75946 "2024-08-28T12:48:07Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**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:** [August 30, 2024, 12:42am UTC](https://community.glideapps.com/t/get-data/75946/7 "2024-08-30T00:42:15Z")

</div>

**Events table**

| Event ID | Event name |
| --- | --- |
| E001 | Event 1 |
| E002 | Event 2 |

**Users table**

| User ID | User name |
| --- | --- |
| U001 | John Doe |
| U002 | Jane Doe |

**Expenses table**

| Event ID | Expense ID | Expense name |
| --- | --- | --- |
| E001 | X001 | Buying BBQ |
| E001 | X002 | Buying wine |

**Expenses payments table**

| Expense ID | User ID | Amount |
| --- | --- | --- |
| X001 | U001 | $5.00 |
| X001 | U002 | $10.00 |

I think you should have a form to add an event, and leave the expenses and payments later.

In the details view of an event, have a collection/form to add an expense, and in an expense, have a form to add payments related to that expense. You can bring over IDs for relations inside the form using special values.

---

_[View the full topic](https://community.glideapps.com/t/get-data/75946)._