Connecting two database table in one form

[mskv1309]

I am working on a form that needs to be connected with two different database table in a form. Do I need to bound my form to one database? If so, then what about other database how will I provide connection and query other database table. Is there any other solution wherein I can query both database table.

[ROCLASI]

Hi,

Are these 2 tables related to each other ? If so you simply create a relationship in Servoy and bind the form to the main table. Then you can add the main table and related table columns to the form.
This should also work even if the tables are in 2 different databases (i.e. connections). Just keep in mind there are some restrictions when linking 2 tables over 2 different connections.

Hope this helps.

[mskv1309]

Both tables are in different database and there is no relation between both tables

[ROCLASI]

Hi,

What it is you want to do exactly ?
Also is this form for view only or do you want to do data-entry and/or search as well ?

[mskv1309]

Need to work on form where user enters information which are in two different unrelated database tables and need to search in foundset whether that info is in database or not.

When user enters Id (which is in one table) I need to search in foundset that id exist or not.

Code: Select all

_foundset=databaseManager.getFoundSet('servername','tablename')
_foundset.loadRecords('SELECT id FROM employee WHERE id=? ORDER BY id', [<somevalue>]); //id is PK.
//some code.


I am able to do so, but for other entered data need to verify too which are in different database (unrelated) table.

My form is not bound with any datasource. Do I need to bound the form? If I have to then to which database I need to bound.