I've been looking all morning but I have no background with Datagrids so I'm probably looking for the wrong things anyway.
I have a table that has a number to show the user's level. I have a related table that contains the text that I want to display rather than the number so basically
user row = id,name,roleid with roleid as an integer
roles row = role,name
So I'd like the datagrid column to display roles.name instead of user.roleid
Easy if I do a select and left join but then I can't use Adapter.update because of multiple tables being involved
I have a table that has a number to show the user's level. I have a related table that contains the text that I want to display rather than the number so basically
user row = id,name,roleid with roleid as an integer
roles row = role,name
So I'd like the datagrid column to display roles.name instead of user.roleid
Easy if I do a select and left join but then I can't use Adapter.update because of multiple tables being involved