Can Session ID be used as identification when data input?

[t4nu]

Hi,
I have a grid link to a table.
If I want allow user to enter their data directly on the grid.
The user only allowed to enter the 1st column, the other column will be displayed automatically depend on the data in column 1.
the grid show add row option is checked.
After tested it, it can add the row, the problem is the other column is not update automatically.
What should I do to make the other column show automatically.
In the database source that used, the target table is linked to other table (the 1st column is the field in the target table, the other column are from the linked table).

Thanks in advance for the help.

[Jon]

I think I understand.. it sounds like you need to get control when the user enters something in your first column - you can do this by clicking the Immediate Validation option for the Column Control then adding an On Change event script that uses the first column to fetch any additional data from the database. This database resource is probably identical to the one used for your fetchtable except it will have a where clause specifying the value of the first column and it will only return one row. This event will also fire when the user changes the first column on an existing row - don't you also have the same issue with this? If you need to, you can check whether a row has been inserted with tables.Mytab.isRowInserted() - this will return true if the row has been inserted, and it's removed when you issue updatetable.