Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Add another table field to jqGrid edit Dialog
Tags: jqgrid
24/03/2012
07:32
Avatar
beryl_peng
New Member
Members
Forum Posts: 1
Member Since:
24/03/2012
sp_UserOfflineSmall Offline

I am very new to jqgrid & also jQuery, so hope to get some help from here. When we click the edit button at the navigator, the default edit dialog will show the fields which we set editable=true, but what if i want to add another table field?

Table Customer Table CustomerBooking
CustomerId BookingId
CustomerName CustomerId

Example: My grid will load the Table Customer (customer Id & Name) but what i want is when i click edit, the edit dialog can show all Booking id related to this customer.

I tried to load the grid with joined SQL (SELECT * FROM Customer A, CustomerBooking B where A.CustomerId = B.CustomerId) with set BookingId (hidden: true), The grid load successfully, but when i click the row, it dont allow me to click on the row due to there are more than 1 row of CustomerId (the relationship is 1 to many, one customerId can have > 1 BookingId).

Is there any way when i click on the row then upon the edit dialog load, only i submit another query to get all the BookingId? Or any example to change edit dialog? Cause i may need to show other information from another table related to this customer.

I have stucked here for a few days Cry, anyone can advise?

Thanks in advance!

Many Many Thanks!

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
75 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information