# How does one setup a parent relationship to the same table with TOPSPEED?

**URL:** <https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249>\
**Category:** questions\
**Tags:** topspeed\
**Created:** [June 4, 2025, 7:15am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249 "2025-06-04T07:15:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![ThaDaSoft](https://clarionhub.com/user_avatar/clarionhub.com/thadasoft/32/3743_2.png) [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\
**Post date:** [June 4, 2025, 7:15am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/1 "2025-06-04T07:15:07Z")

</div>

For a specific table I would love to use a parent relationship to the same table, this way I can prevent duplication of data (else I would need to repeat the parent data for each child, or use it without a relationship) - but when trying to set this up, I cannot select the same table in the `1:MANY` or `MANY:1` options, it disappears from the dropdown - is this just not supported? Or is there a way to set this up?

---

<div class="post-metadata">

**Author:** ![Clarion\_clarion](https://clarionhub.com/user_avatar/clarionhub.com/clarion_clarion/32/636_2.png) [@Clarion\_clarion](https://clarionhub.com/u/Clarion_clarion)\
**Post date:** [June 4, 2025, 7:29am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/2 "2025-06-04T07:29:00Z")

</div>

have you tried to use Alias?

---

<div class="post-metadata">

**Author:** ![ThaDaSoft](https://clarionhub.com/user_avatar/clarionhub.com/thadasoft/32/3743_2.png) [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\
**Post date:** [June 4, 2025, 7:42am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/3 "2025-06-04T07:42:46Z")

</div>

Sorry, but what’s Alias?

---

<div class="post-metadata">

**Author:** ![Clarion\_clarion](https://clarionhub.com/user_avatar/clarionhub.com/clarion_clarion/32/636_2.png) [@Clarion\_clarion](https://clarionhub.com/u/Clarion_clarion)\
**Post date:** [June 4, 2025, 8:00am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/4 "2025-06-04T08:00:42Z")

</div>

![image](https://clarionhub-uploads.s3.eu-north-1.amazonaws.com/original/2X/a/a4d383ce3eb836049fb4d37f0b8801ce4d703dce.png)

An alias creates a second reference for a table without duplicating the file on disk.

---

<div class="post-metadata">

**Author:** ![ThaDaSoft](https://clarionhub.com/user_avatar/clarionhub.com/thadasoft/32/3743_2.png) [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\
**Post date:** [June 4, 2025, 8:10am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/5 "2025-06-04T08:10:34Z")

</div>

And you can create a relationship between a table and it’s alias?

---

<div class="post-metadata">

**Author:** ![Clarion\_clarion](https://clarionhub.com/user_avatar/clarionhub.com/clarion_clarion/32/636_2.png) [@Clarion\_clarion](https://clarionhub.com/u/Clarion_clarion)\
**Post date:** [June 4, 2025, 8:13am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/6 "2025-06-04T08:13:56Z")

</div>

have YOU tried to use Alias? 😄

---

<div class="post-metadata">

**Author:** ![ThaDaSoft](https://clarionhub.com/user_avatar/clarionhub.com/thadasoft/32/3743_2.png) [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\
**Post date:** [June 4, 2025, 8:46am UTC](https://clarionhub.com/t/how-does-one-setup-a-parent-relationship-to-the-same-table-with-topspeed/8249/7 "2025-06-04T08:46:49Z")

</div>

Just did - thanks for the help - was busy looking why a PUT gives me a `Creates duplicate key` error…