jQuery Grid Plugin - jqGrid

well .. i dunno how to simplify this.. the condition is...  I have a form to keyin basic info ..

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

to add some more query which are related to this.. 

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..!!!

tony .. can this prod id field be interactive.. meaning.. when i choose the prod_name through a multi select list (droop down menu).. the prod id field will also change to the correspondence value?? ..  + is is possible to create a link multi select list..???