# \#gtrr

**URL:** https://the.fmsoup.org/tag/gtrr/739.md

[Latest](https://the.fmsoup.org/latest.md) · [Categories](https://the.fmsoup.org/categories.md) · [Tags](https://the.fmsoup.org/tags.md)

---

## [Updating Related Records](https://the.fmsoup.org/t/updating-related-records/4457)

<div class="topic-metadata">

**Author:** [@steverichter](https://the.fmsoup.org/u/steverichter)\
**Replies:** 8\
**Last updated:** [November 11, 2024, 4:29pm UTC](https://the.fmsoup.org/t/updating-related-records/4457 "2024-11-11T16:29:34Z")

</div>

I have two tables, INVOICE\_ITEMS\_TEMP and INVENTORY. The common field is itemNo. Each week, I truncate the IIT table, and import new invoice records. The IIT table typically has 100 records. The second (INVENTORY) table…