jQuery Grid Plugin - jqGridForum

Topic RSS

Table lookup

07/05/2009
09:50

agrings

Member

Members

Forum Posts: 4

Member Since:
30/04/2009

Offline

Is there a way of doing table lookup?

Example:

inv_header(id,inv_date,...,client_id,...)

clients (client_id,name).

Is it possible to search for the client name and then update client_id in the inv_header table?

Thanks in advance,

Alexandre

09/05/2009
09:34

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

Sorry do not understand.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

16/07/2009
13:59

agrings

Member

Members

Forum Posts: 4

Member Since:
30/04/2009

Offline

Hi Tony,

Lets consider the example Form improvements (version 3.5 beta demos).

Suppose the “ship via” field has a huge amount of options. Suppose all shipping options are stored in a table named shipping_company:

I would like to code a search dialog in order to search by “company_name” in the “shipping_company” table and then return the corresponding ship code to fill Invoice.ship_via field.

Regards,

Alexandre

20/07/2009
11:11

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

Hello,

I think you should use autocomplete plugin for this purpose.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
74 Guest(s)

Currently Browsing this Page:
1 Guest(s)