# DbtreeView multilevel(3 level) isssue

**URL:** <https://forum.servoy.com/t/dbtreeview-multilevel-3-level-isssue/11400>\
**Category:** Classic Servoy\
**Created:** [November 14, 2009, 11:14pm UTC](https://forum.servoy.com/t/dbtreeview-multilevel-3-level-isssue/11400 "2009-11-14T23:14:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![madimane](https://avatars.discourse-cdn.com/v4/letter/m/779978/32.png) [@madimane](https://forum.servoy.com/u/madimane)\
**Post date:** [November 14, 2009, 11:14pm UTC](https://forum.servoy.com/t/dbtreeview-multilevel-3-level-isssue/11400/1 "2009-11-14T23:14:38Z")

</div>

Hi all,

I’m trying to do a simple solution that have one form having DBTreeview with 3 level but  
unfortunately it shows me just 2 level!!!  
Here’s my function I call on the show form event.

```auto
function loadTree()
{
	var tree_customers = elements.bean_859.createBinding(controller.getServerName(), 'customers')
	var tree_orders = elements.bean_859.createBinding(controller.getServerName(), 'orders')
	var tree_orderDetails = elements.bean_859.createBinding(controller.getServerName(), 'order_details')

	tree_customers.setNRelationName('customers_to_orders')
	tree_orders.setNRelationName('orders_to_order_details')
	
	tree_orders.setNRelationDataprovider('clients_to_projects')
	tree_orderDetails.setNRelationDataprovider('orders_to_order_details')
	
	tree_customers.setTextDataprovider('customerid') 
	tree_orders.setTextDataprovider('orderid') 
	tree_orderDetails.setTextDataprovider('productid') 

	var fs = databaseManager.getFoundSet(controller.getServerName(), 'customers')
	fs.find()
	fs.search(true, true)
	fs.loadRecords()
	elements.bean_859.addRoots(fs);
}

```

here’s my solution based on “example\_data” database  
I’m using servoy 4.1.4

If someone has an idea of what’s the problem or what am I missing? I’m grateful.

[DbTreeviewMultiLevelTest.servoy](https://forum.servoy.com/uploads/short-url/etCw2yJRa0YQgi1KbRDDpNBkDh7.servoy) (5.36 KB)

---

<div class="post-metadata">

**Author:** ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)\
**Post date:** [November 17, 2009, 10:28am UTC](https://forum.servoy.com/t/dbtreeview-multilevel-3-level-isssue/11400/2 "2009-11-17T10:28:35Z")

</div>

These lines are a little weird:

```auto
tree_orders.setNRelationDataprovider('clients_to_projects')
tree_orderDetails.setNRelationDataprovider('orders_to_order_details')

```

With setNRelationDataprovider() you can set a dataprovider(column or calculation) that returns a relationname that is used to get the nodes of the next level.

For tree\_orders, you set the NRelationName before to “orders\_to\_order\_details”, so no need to set it again. tree\_orderDetails is already the lowest level, so no need to set a NRelationDataprovider.

I think you should just delete these two lines, that will probably solve your problem.

---

<div class="post-metadata">

**Author:** ![madimane](https://avatars.discourse-cdn.com/v4/letter/m/779978/32.png) [@madimane](https://forum.servoy.com/u/madimane)\
**Post date:** [November 17, 2009, 2:22pm UTC](https://forum.servoy.com/t/dbtreeview-multilevel-3-level-isssue/11400/3 "2009-11-17T14:22:13Z")

</div>

Thank you joas for the reply,

you are right, the problem is solved.

thank you for the explanation ![:)]( "Smile")