I have a form in which i insert date,station_id,production
each station has many distillers like(station A has D1,D2,D3)and the total of the D1,D2,D3 is the prodction of the station.
i have a table named distillers:
what i want to do is to let the user see the station form to insert date,station_id and to make a link next to production textbox that opens a new pop up window and this window has:
date(same as inserted in station form,distiller_id ,production)
what i want is to list all the distillers related to this station like in Station A it will show me a form in this way:
date:(as the one entered in stationA form)
D1: , storage:
D2: , storage:
D3: , storage:
and that form will insert the values into distillers table:
so each distiller will save the same form date with storage entered,
at last in the stationA form i want after submitting the result of the distiller form the window closes and the production field in the stationA form hold or shows the total of the 3 distillers entered through the pop up window.
I know its a bit difficult and confusing but i really need help in that and if i can give more than 500 points ,i will.