# Relation based on view

**URL:** <https://forum.servoy.com/t/relation-based-on-view/14864>\
**Category:** Classic Servoy\
**Created:** [October 13, 2011, 2:03pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864 "2011-10-13T14:03:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![tizzo](https://avatars.discourse-cdn.com/v4/letter/t/bbe5ce/32.png) [@tizzo](https://forum.servoy.com/u/tizzo)\
**Post date:** [October 13, 2011, 2:03pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864/1 "2011-10-13T14:03:08Z")

</div>

I’m trying to create a relation between a table and (on the right side) a view.  
It seems to me it’s possible since Servoy lets me design such a kind of relation…  
but I still get an empty foundset.  
am I doing right or there’s something wrong in the relation’s design?

thx in advance

---

<div class="post-metadata">

**Author:** ![mboegem](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/mboegem/32/4399_2.png) [@mboegem](https://forum.servoy.com/u/mboegem)\
**Post date:** [October 13, 2011, 2:54pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864/2 "2011-10-13T14:54:14Z")

</div>

Did you mark the row-identifier(s) in Servoy? Without this Servoy doesn’t know what to query…

---

<div class="post-metadata">

**Author:** ![tizzo](https://avatars.discourse-cdn.com/v4/letter/t/bbe5ce/32.png) [@tizzo](https://forum.servoy.com/u/tizzo)\
**Post date:** [October 13, 2011, 3:06pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864/3 "2011-10-13T15:06:23Z")

</div>

yes I did.  
i’ve tried many ways, simplifying to only one constant value field, making some simple calculation, etc…  
but i still can’t get it work  
 ![:(]( "Sad")

---

<div class="post-metadata">

**Author:** ![mboegem](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/mboegem/32/4399_2.png) [@mboegem](https://forum.servoy.com/u/mboegem)\
**Post date:** [October 13, 2011, 9:23pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864/4 "2011-10-13T21:23:03Z")

</div>

Did you try to query this view directly through an SQL-admin tool?

Also be aware that the data in a view is always altered from outside Servoy. So: once a result is cached in Servoy, you won’t see changes in this result unless you completely refresh the foundset from database. As Servoy is only aware of db-changed done through a Servoy-client.

Depending on the ‘cost’ of your view, this might be anot do ideal solution to show your data.

---

<div class="post-metadata">

**Author:** ![tizzo](https://avatars.discourse-cdn.com/v4/letter/t/bbe5ce/32.png) [@tizzo](https://forum.servoy.com/u/tizzo)\
**Post date:** [October 27, 2011, 3:25pm UTC](https://forum.servoy.com/t/relation-based-on-view/14864/5 "2011-10-27T15:25:10Z")

</div>

you were right. I’ve redone it all from a blank situation and now it’s ok.  
It was probably a type mistake or my vision is getting worse, i don’t know ![:wink:]( "Wink")  
thx