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:
- Code: Select all
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..