showing information 2 relations away

Classic Servoy
1

Hi,

I want to show information on a form that is two relations away.

If there is only one relation, I can simply show it by . and it will show and i can search on it.

I use an unstored calculation now that contains return ..

The data is shown correct, but i can not search on it because it is an unstored calc.

Is there another way to do this, so I can search ??

( not by denormalizing )

Regards.

2

You can use a wrapper form. So if your relation tables are A > B > C, make a form based on B, that has only a tabpanel that displays the C relation, then place the B form in a tabpanel on the A form.

Did that make sense? Sort of hard to describe in a useful way.

greg.

3

Thanks,

Makes sense, i’ll tyr it.

Regards,

Hans

4

Tried this, but it is not the solution.

The records I want to show are in form C’s table and the field I want to show/search with each record in form C is in form A’s table
so it is still 2 relations (up) away.

Regards,

Hans

5

Hi Hans,

What Greg means is you use 3 forms.
Form A is your main form, Form B is just a portal form with a hidden tabpanel that loads Form C.
Since 3.5 you should be able to use this method to use find mode to search 2 relations away. Previous versions couldn’t do that yet.

Hope this helps.

6

Okay , now i get it :idea:

Altough this will only work in recordview and not in listview or tableview.

Thanks guys,

Hans

7

To DISPLAY data 2 relations away (in a list or tableview) - you can do it two ways:

a) Use a valuelist and a N-M relation
b) Use a field (or label) with the “displaytags” property checked and this value for the “text” property: %%relation1.relation2.fieldname%%