Working with two different database table in the form

Classic Servoy
1

I have created a form with labels and text field. Need to validated data once user enter data against data in two different (database) unrelated tables.

As the form is bound to one datasource, how I can create two datasource for two different database table?

Please guide.
Thank you in advance.

2

You can create a new form for the second datasource and show that in an unrelated tab panel of the first form.

3

I’ve read again your post, maybe I’ve been too quick in replying.
If you only need to show/get data for one datasource one form is enough, if you then need to validate against that datasource and another one you can use something like this:

if(forms.a.my_column) .... // main datasource checks...

var _foundset = databaseManager.getFoundset('my_server','my_table')
_foundset.find()
 _foundset.my_column = 'whatever' // load the records that you need to check against
_foundset.search()

if(_foundset.getRecord(1).myOtherColumn) // checks on the first record of the foundset

I hope you get the idea…

4

Thanks for the quick response.

Can you please provide me more information for to load particular column records in foundset

Thank you once again