The method I mentioned for Pete was setting a column with the needed id. If you are talking about the problem with the select input (Post returns value as it should but then when we load value, it displays value and not label 🙁 ) I had to do some serverside juggling to display the results correctly.

Cheers,
P.

Did this work for you? I've got a grid with several foreign keys. I made it work, but I'm looking for a cleaner way.

Barry

Cheers,
P.

Yes, that's exactly what I want to do! Thank you!

(I'm still a newbie at JQuery stuff, so sometimes the basic real answers get lost in the noise!)

Thanks again.

Pete.

I'm not quite sure I get what you want to do, but try the following:

Pass the salesrepid as a colum also, set key:true and hidden:true. Column salesrep should be there also but visible. That way you can reference salesrepid and view salesrep.

Hopes this helps

P.

I have a database in 3rd normal form; simplistic structures as follows;

branch:

branchid integer,

salesrepid integer,

branchaddress char(255);

salesrep:

salesrepid integer,

salesrepname char(50);

When I display the table of branches, it shows the sales rep ids, not their names.

I need the sales rep ids in there so that I can record updates, but I only want the customer to see the sales rep name.

Using JSON, the colmodel for the branch sales rep is as follows;

{name:'salesrep',index:'salesrep', width:90, editable: true, edittype:"select", editoptions:{value:"0:Fred;1:George;2:Noah"} },

So from this, I'd like the customer to see Fred, George and Noah as drop down options (this works), and when the customer just looks at the list of branches, he sees the correct foreign key reference - Fred, George or Noah as appropriate, and NOT 0,1 or 2, which is what happens at present.

What am I doing wrong?

Regards,

Pete.