Dataset

A Dataset represents a complete set of data including the tables that contain, order, and constrain the data, as well as the relationships between the tables.

How to get dataset

Create a new behavior. Put the appropriate caption. Click Action wizard.

Click Create an action.

Click Other Scribe Functions.

Select Get Dataset in Other Scribe Functions dropdown. Click OK.

Click Save changes.

Click View code. This example of default code:

Change form name, field name and value accordingly. This code will set to display information if Department equal to 'Dep1'.

Add this below code after the default code. This code will display Admin Name and Department which department equal to 'Dep1'

Dim deptTable as Datatable=Data("Display")
Dim idept as Integer=0

If _Set151731 is nothing=false then
    If _Set151731.tables(0).rows.count>0 then
        for idept=0 to _Set151731.tables(0).rows.Count -1 
            dim _rowBInewxc as datarow=deptTable.NewRow()
            dim _rowBIxc as datarow = _Set151731.Tables(0).Rows(idept)
            
            _rowBInewxc("Department") = scribe.GetText(_rowBIxc("Department"))
            _rowBInewxc("AdminName") = scribe.GetText(_rowBIxc("Admin Name"))
            
            deptTable.rows.add(_rowBInewxc)
        next
    End If
End If

Data("Display") = deptTable

Screenshot as per below. Click Check Syntax, if no error then click Save and close.

Click Create now.

Example how it look in the form: