I'm using jqGrid to display data retrieved from relational db (SQLite). I need to display some related fields, for blog Post I want to display User.name column (retrieved from Post.user_id) .

I could simply remove user_id column and put "username" column (result of JOIN), this however won't work for editing - my model validator requires user_id to be provided.

Is there any known way for doing such a thing (i.e. by incorporating Autocomplete which will set hidden user_id value)?