jQuery Grid Plugin - jqGrid

Hello guys,

I have some problem with foreign key fields.

For example, I have 2 tables Clients and Orders.

In table Orders I have key field to table Clients.

Of couse in grid I have to show Name of client instead key value.

No problem if it is readonly grid, but if I need edit mode I get problem.

I have to have in one field 2 values from server, key for edit mode and title to show in the grid.

As I understand it is not possible now.

Of couse I can send 2 fields from server, ClientID (hidden) and ClientName.

Well, but what to do now?

In edit form I need to have something like combobox, but it is not possible to use combobox, because table Clients has to many records.

I need to have lookup fields with ajax searching (autocomplete) in table Clients and save just a key.

… maybe button which open new modal grid with Clients table, where user can select record and save key in edit form.

I am sure, I am not first who need to do it.

Any example how it is possible to resolve my problem ?

Thanks & Best  regards

Evgeny

P.S.

jqGrid is BEST