# Manually specify relationship

**URL:** <https://community.dreamfactory.com/t/manually-specify-relationship/1829>\
**Category:** Schema & Data\
**Created:** [November 24, 2015, 8:55pm UTC](https://community.dreamfactory.com/t/manually-specify-relationship/1829 "2015-11-24T20:55:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![greatwitenorth](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/greatwitenorth/32/487_2.png) [@greatwitenorth](https://community.dreamfactory.com/u/greatwitenorth)\
**Post date:** [November 24, 2015, 8:55pm UTC](https://community.dreamfactory.com/t/manually-specify-relationship/1829/1 "2015-11-24T20:55:22Z")

</div>

I’m just getting started with Dreamfactory and I’ve setup a wordpress db as a service. Wordpress doesn’t use foreign keys so Dreamfactory doesn’t pick up on the relationships. Is it possible to specify the relationships without physically creating foreign keys in the database?

---

<div class="post-metadata">

**Author:** ![benbusse](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/benbusse/32/4_2.png) [@benbusse](https://community.dreamfactory.com/u/benbusse)\
**Post date:** [November 25, 2015, 6:41am UTC](https://community.dreamfactory.com/t/manually-specify-relationship/1829/2 "2015-11-25T06:41:09Z")

</div>

See comments here, coming next week…

> [@Virtual Primary and Foreign keys?](https://community.dreamfactory.com/t/virtual-primary-and-foreign-keys/1831):
>
> Hi, getting started using Dreamfactory, looks great. Using MS SQL as source, having two related views without any primary and foreign keys; how can I make the relationship between the two tables without the possibility to change the schema on the database itself ? Is it possible to make “virtual” primary and foreign keys for Dreamfactory only, Tried to mark a field on the a table in the Dreamfactory admin UI, but it tries to set on the database as well ? Any ideas ? Thx for your input in adva…

---

<div class="post-metadata">

**Author:** ![greatwitenorth](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.dreamfactory.com/greatwitenorth/32/487_2.png) [@greatwitenorth](https://community.dreamfactory.com/u/greatwitenorth)\
**Post date:** [November 25, 2015, 4:04pm UTC](https://community.dreamfactory.com/t/manually-specify-relationship/1829/3 "2015-11-25T16:04:28Z")

</div>

This looks great! Thanks for the heads up.