# Foreign Key naming

**URL:** <https://forums.toadworld.com/t/foreign-key-naming/2613>\
**Category:** Toad Data Modeler\
**Created:** [December 21, 2011, 4:28pm UTC](https://forums.toadworld.com/t/foreign-key-naming/2613 "2011-12-21T16:28:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Klunky](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@Klunky](https://forums.toadworld.com/u/Klunky)\
**Post date:** [December 21, 2011, 4:28pm UTC](https://forums.toadworld.com/t/foreign-key-naming/2613/1 "2011-12-21T16:28:33Z")

</div>

I am a new user of TDM, so forgive me if this is a stupid question. I would like to be able to name a foreign key something specific, like FK\_ADDRESS\_CUST\_ID, but I would like the “caption” of the relationship to show up on the model as “has a”. In the rare case it will let me, I have tried making the Caption = “has a” and the Name = FK\_ADDRESS\_CUST\_ID (usually it won’t let me make the caption and name different), but it still shows up on the model saying FK\_ADDRESS\_CUST\_ID.

How do I have the caption be the “phrase” and the name be the actual FK object name?

---

<div class="post-metadata">

**Author:** ![admin1](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@admin1](https://forums.toadworld.com/u/admin1)\
**Post date:** [December 22, 2011, 3:38am UTC](https://forums.toadworld.com/t/foreign-key-naming/2613/2 "2011-12-22T03:38:12Z")

</div>

Hi,

to have a relationship Caption different from Name you must edit Name field in any way first, which will change the Synchronize button between the Caption and Name fields from “_=_” to “_\>_”.  
Then you can change the Caption and Save.

Regards,  
Lukas  
 ![CaptionNameSynchro.png](https://global.discourse-cdn.com/quest/original/2X/c/c81f23ac90161f25ddffb22990f7a1ca43b6bff7.png)

---

<div class="post-metadata">

**Author:** ![Klunky](https://avatars.discourse-cdn.com/v4/letter/k/e480ec/32.png) [@Klunky](https://forums.toadworld.com/u/Klunky)\
**Post date:** [December 22, 2011, 4:11pm UTC](https://forums.toadworld.com/t/foreign-key-naming/2613/3 "2011-12-22T16:11:07Z")

</div>

Thank, Lukas!

I found that I also need to change the Display Mode to “Captions” if I want to show the captions on the model versus the Names. View | Display Mode | Captions.

---

<div class="post-metadata">

**Author:** ![admin1](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@admin1](https://forums.toadworld.com/u/admin1)\
**Post date:** [December 23, 2011, 2:34am UTC](https://forums.toadworld.com/t/foreign-key-naming/2613/4 "2011-12-23T02:34:16Z")

</div>

Hi Amy,

you're welcome. Never hesitate to ask here any questions!  
Anyway, you can also change the Display Mode on toolbar.

Regards,  
Lukas

 ![CAptions.png](https://global.discourse-cdn.com/quest/original/2X/1/1b00d4d730d977de7ee5e2003bf67da9207e43bd.png)
