I hv 2 table :

1. table A : i) Name ii)prod_id iii)amount

2.table B : i)prod_id ii)prod_name

so in my grid user will see i)name ii)prod_name iii)amount.. my prob is how to save them into the database.. because currently the colModel is under prod_name.. so how can I get back the prod_id from the prod_name to be save into table A. Or how can I just add another colModel for prod_id which will be hidden but its value will change dependable of prod_name selection..

heeeelllppppp..!!!

I hv 2 table :

1. table A : i) Name ii)prod_id iii)amount

2.table B : i)prod_id ii)prod_name

so in my grid user will see i)name ii)prod_name iii)amount.. my prob is how to save them into the database.. because currently the colModel is under prod_name.. so how can I get back the prod_id from the prod_name to be save into table A. Or how can I just add another colModel for prod_id which will be hidden but its value will change dependable of prod_name selection..

heeeelllppppp..!!!

let say about claim:  userid .. projectid .. + purpose (this part is not that important though hehe.. )

this form will generate an id .. to be pass to another form.. which is detail information on the claim which include let say

1. item 2. date 3. amount 4. amount budget 5. amount used..

I managed to solve the first problem andused autocomplete.. 

so now when I select an item [1. item] .. (through autocomplete)

I WANT the field for '4. amount budget' and '5. amount used' to be automatically fill in from 2 or more tables.

do u hv any idea how to do this.. some hint or samples would be nice..

thnx

I'm not sure that I understand.

What you mean with

jqgrd will grab new product id from a form which will be submitted to grid

I think that where you grab the product id you should fill automatically the fields that should not be filled from the user.

Best Regards

Tony

I would like 2 know if it possible: I hv 2 linked table from db let say tbl_A and tbl_B,

which is linked through let say prod_code

so what i hv in mind is .. jqgrd will grab new product id from a form which will be submitted to grid.. so grid will generate a datatable.. which have 5 column... 3 of those column grab data from tbl_B.. so user will only need to fill in last 2 column..

for example.. when a form is submitted with prod_id 13.. grid will fill in column 1 with the new id, column 2 with the date and column 3 with the prod_code... so we will hv 3 column fill in automatically.. user then will only need to fill in the last 2 column..

row1: id>13 [tbl_A]   date>8 apr [tbl_A]     prod_code>Nz112 [tbl_B]    amount>[~fill in by user~]    unit price>[~fill in by user~]

row1: id>13 [tbl_A]   date>8 apr [tbl_A]     prod_code>Nz145 [tbl_B]    amount>[~fill in by user~]    unit price>[~fill in by user~]

row1: id>13 [tbl_A]   date>8 apr [tbl_A]     prod_code>Nb412 [tbl_B]    amount>[~fill in by user~]    unit price>[~fill in by user~]

row1: id>13 [tbl_A]   date>8 apr [tbl_A]     prod_code>Az133 [tbl_B]    amount>[~fill in by user~]    unit price>[~fill in by user~]

and so on...

 anyone..?? tony??