# \#related-records

**URL:** https://the.fmsoup.org/tag/related-records/300.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…

---

## [Finding Related Records](https://the.fmsoup.org/t/finding-related-records/4248)

<div class="topic-metadata">

**Author:** [@steverichter](https://the.fmsoup.org/u/steverichter)\
**Replies:** 13\
**Last updated:** [September 21, 2024, 6:49pm UTC](https://the.fmsoup.org/t/finding-related-records/4248 "2024-09-21T18:49:17Z")

</div>

I have two tables (TRANSACTIONS and HOLDLINES). Each table contains the field CUSTOMER\_ID. I want to determine if both tables contain the same customer\_ID. Options: (a) Save the ID and then Go to Layout B and perform a …

---

## [Sumifs equivalent](https://the.fmsoup.org/t/sumifs-equivalent/2441)

<div class="topic-metadata">

**Author:** [@cpking](https://the.fmsoup.org/u/cpking)\
**Replies:** 8\
**Last updated:** [September 9, 2021, 9:12pm UTC](https://the.fmsoup.org/t/sumifs-equivalent/2441 "2021-09-09T21:12:42Z")

</div>

I'm back trying to essentially cross-tab some data. I have a solution with multiple related tables. A songbook table which includes a song title, duration, etc. A gig table which includes information like performance …

---

## [The FileMaker API \> Create Record](https://the.fmsoup.org/t/the-filemaker-api-create-record/1115)

<div class="topic-metadata">

**Author:** [@tonywhitelive](https://the.fmsoup.org/u/tonywhitelive)\
**Replies:** 4\
**Last updated:** [June 30, 2020, 8:13pm UTC](https://the.fmsoup.org/t/the-filemaker-api-create-record/1115 "2020-06-30T20:13:40Z")

</div>

Hi All, The FileMaker API docs for Create Record defines the Payload as... { "fieldData": {}, "portalData": {}, "script": "string", "script.param": "string", "script.prerequest": "string", "script.prerequest.para…