Relations to other schemas in the same form

Classic Servoy
1

We have the following setup in our system.

We have two different schemas in an oracle database (“schema1” and “schema2”).
One form is connected directly to “table1” in “schema1”.
We have a relation from “table1” in “schema1” to “table2” in “schema2”. This works in Servoy.
Now there is also a relation between “table2” and “table3” both in “schema2”.
We would like to include this relation in our form, but it is not available in the relation drop down.

Is it possible to do this? Or are we going to have to put all of our schemas into one big schema (ugly!)?

Thank you,
Tobias

2

Servoy has two options to make it available as a relation:

a) create the relation yourself in the relation dialog (this can be any relation between any database)
b) read constraints (PK-FK relations) from your schema using the Create button in the relations dialog

3

Thanks jaleman,

I solved the problem by connecting two relations together to get from “table 1” to “table 2” then, from “table 2” to “table 3”.

Tobias