I have a form with 2 tabs: left is a list of all contacts, right the contacts details. I need to find a contact in the right tab by his pk, and select in the left tab the contact.
My method is:
- Code: Select all
var x = forms.contacts_join.conjoin_rel2
var serverName = forms.nav_contacts.controller.getServerName()
var query = "SELECT cont_id_rel FROM contacts WHERE cont_id_rel ="+ x;
var dataset = databaseManager.getDataSetByQuery (serverName, query, null, 100);
forms.nav_contacts.controller.loadRecords(dataset)
forms.nav_contacts.controller.loadAllRecords()
Everything works right if the contact is in range of the 200 records loaded on the left side. If not it jumps to the first one.
Can somebody help with this one please?