# Item Movement Log

**URL:** https://community.glideapps.com/t/item-movement-log/15438
**Category:** Ask for Help
**Created:** [September 8, 2020, 5:03am UTC](https://community.glideapps.com/t/item-movement-log/15438 "2020-09-08T05:03:03Z")
**Posts on this page:** 1
**Showing post:** 9

<div class="post-metadata">

### Author: ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)
#### Post date: [November 11, 2020, 1:42pm UTC](https://community.glideapps.com/t/item-movement-log/15438/9 "2020-11-11T13:42:50Z")

</div>

> [@Manan\_Mehta](#):
>
> Instead of having a column for possession in the same sheet, create a new sheet for possession logs.  
> In that sheet, have columns of timestamp, item SKU (Unique ID of item), customer email and possession and then create a multiple relation of this sheet with your items sheet using the item SKU.

Hi @Manan_Mehta, in continuation of this, I have a multiple relations (movements to the main item). However, when I delete the main item (this is necessary in my App for users), the movements log remains there in the Log sheet.

Any idea how can we achieve this @ThinhDinh @Jeff_Hager @Robert_Petitto ? (i.e. when I delete main item in sheet, it deletes all corresponding movements in Log Sheet). Can Compound Action will help here?

Thanks

---

_[View the full topic](https://community.glideapps.com/t/item-movement-log/15438)._