# Auto-Discovery of existing database relations

**URL:** <https://forum.servoy.com/t/auto-discovery-of-existing-database-relations/4885>\
**Category:** Classic Servoy\
**Created:** [October 14, 2005, 10:43am UTC](https://forum.servoy.com/t/auto-discovery-of-existing-database-relations/4885 "2005-10-14T10:43:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Huber](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@Robert\_Huber](https://forum.servoy.com/u/Robert_Huber)\
**Post date:** [October 14, 2005, 10:43am UTC](https://forum.servoy.com/t/auto-discovery-of-existing-database-relations/4885/1 "2005-10-14T10:43:15Z")

</div>

Hi All

Designing my database with EOModeler (btw part of XCode now, i.e. for free ![:-)]( "Smile"), I create the SQL code out of it and have the (iAnywhere) database - very good so far.  
Now I let Servoy auto-detect existing relations. I get all 1:m (primary to foreign key relations, because of the foreign key constraints). But I do not get the relations in the other direction, i. e. from the m to the 1 side. As servoy knows the 1:m relation, it could also create the m:1 relation, couldn’t it? Am I missing something or do I have to create all m:1 relations manually (which I don’t like to do of course)?

Best regards, Robert
