# Relationship using Telephone Numbers (text)

**URL:** <https://community.noloco.io/t/relationship-using-telephone-numbers-text/751>\
**Category:** Bugs\
**Created:** [May 28, 2024, 11:40am UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751 "2024-05-28T11:40:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [May 28, 2024, 11:40am UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/1 "2024-05-28T11:40:27Z")

</div>

Hello,

I think that this is a bug… details below:

I would like to create a relationship (via an automatic link) between two Noloco tables:

Table 1 = Contact Numbers – contains Telephone numbers (primary key, text format) and corresponding contact details.

Table 2 = Call Log – which contains Telephone call logs. There is a ‘number key’ (text field) which is the telephone number. This matches the telephone number primary key in the Contact Numbers table.

It’s a one-to-many relationship - there will be many calls in the Call Log table for each contact number in the Contact Numbers table.

The issue:

In the Call Log table, I add a relationship column, select the Contact Numbers table, but at this point, the Choose a field type changes to Phone Number. I’ve attached a screenshot that might help.

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/1dcb4644627c35edd74640b59c1816698bcb7053.png)

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [May 28, 2024, 12:47pm UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/2 "2024-05-28T12:47:58Z")

</div>

I might be able to explain this, thanks for the details, would you be able to send me a link to this page, please?

---

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [May 28, 2024, 1:00pm UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/3 "2024-05-28T13:00:25Z")

</div>

Great, thanks Darragh. Here is a link:  
[https://cizict.noloco.co/\_/data/internal/myImportedCsv?lt=data](https://cizict.noloco.co/_/data/internal/myImportedCsv?lt=data)

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [May 28, 2024, 1:16pm UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/4 "2024-05-28T13:16:35Z")

</div>

Thanks for bringing that to our attention, as you can probably assume, that is because of your table `Contact Numbers` which is internally named `phoneNumber` and thus clashing with how we temporarily store the field type…

We could look at updating that process, or I could rename your other table…

How would you like to proceed?

---

<div class="post-metadata">

**Author:** ![cizict](https://avatars.discourse-cdn.com/v4/letter/c/b4bc9f/32.png) [@cizict](https://community.noloco.io/u/cizict)\
**Post date:** [May 28, 2024, 1:26pm UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/5 "2024-05-28T13:26:52Z")

</div>

Please rename the table Darragh. Thanks

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [May 29, 2024, 3:37pm UTC](https://community.noloco.io/t/relationship-using-telephone-numbers-text/751/6 "2024-05-29T15:37:16Z")

</div>

> [@cizict](#):
>
> [https://cizict.noloco.co/\_/data/internal/myImportedCsv?lt=data](https://cizict.noloco.co/_/data/internal/myImportedCsv?lt=data)

Sorry for the delay, but we’ve renamed that table for you (which isn’t trivial FYI so if you see something missing just let me know)

![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/c3a1a6d8815820c83d3cf2862afa9cf81e3067bf.png)
