related field (two relations deep)

Classic Servoy
1

I would like to set a field to a value two relations deep. Now one relation is only possible.

Is this possible?

2

HJK:
I would like to set a field to a value two relations deep. Now one relation is only possible.

Is this possible?

relation.relation.dataprovider = value

eg

customers_to_orders.orders_to_order_details.quantity=23

note that this can have unexpected effects if you have 1-n-m relations.

3

But Jan, how do I do this in a field on a form?

4

Not possible with a field. You can use labels only.

5

HJK:
But Jan, how do I do this in a field on a form?

assuming you have customers-orders-orderdetails
create a form on orders that show a related field from orderdetails
place that in a tabless-borderless-tabpanel on the customers screen

6

patrick:
Not possible with a field. You can use labels only.

How do you do that? I can’t select more than one relation in the dataprovider of the label!

7

don’t use a dataprovider but the text property. There you can type

%%relation_a.relation_b.column%%
8

oke labels work!

Servoy guys: Can you make this work for fields too?
So we have a consistant look of fields (labels are shown different than fields)

9

I would like to see that, too. Just wonder how the interface would look like. Maybe the property “dataprovider” just becomes an input field with a button to choose one of the fields like today?

10

patrick:
I would like to see that, too. Just wonder how the interface would look like. Maybe the property “dataprovider” just becomes an input field with a button to choose one of the fields like today?

Or just like in labels: set the Text property!
8)

11

But thats a lot of clicking involving a dialog just to choose a field, isn’t it?