Hi!

I'm using an ultragrid control for displaying and editing data from a db. the data is stored in 3 tables :

- users (user_id, name)
- roles (role_id, role_name)
- user_roles(user_id, role_id);

 I managed to add them to a dataset, and display it in the ultragrid using this code : 

_cmd = new OracleCommand("select * from um_users", _conn);

_odaUsers = new OracleDataAdapter();

_usersDataSet = new DataSet("um_users");

_odaUsers.SelectCommand = _cmd;

_odaUsers.Fill(_usersDataSet, "um_users");

_cmd = new OracleCommand("select u.user_id, r.role_id, r.role_name, r.descr " +

"from um_users u " +

"inner join um_user_roles ur on u.user_id = ur.user_id " +

"inner join um_roles r on ur.role_id = r.role_id ", _conn);

_odaUsers.SelectCommand = _cmd;

_odaUsers.Fill(_usersDataSet, "um_users_roles");

_usersDataSet.Relations.Add("users_uur", _usersDataSet.Tables[0].Columns["USER_ID"], _usersDataSet.Tables[1].Columns["user_id"]);

This snippet allows me to display the data corectly 
and save it for the parent users band, but 
does not do the job after editing or inserting
 a new row in the child roles band.
What am i missing, what should i do in 
order that the data displayed in in child band to 
be saved 
corectly ?

thanks,
Marius.