Forum



07:32

24/03/2012

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 , anyone can advise?
Thanks in advance!
Many Many Thanks!
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.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66