hi,
i need to know, how to make a selection from a field (i.e. Student ID) in a form from a database that will instantly display the rest of the details for the selected item.

next, how can i update instantly to my access database, let say i have enrolled this staff into a course with the cost 500. then i view the staff budget details, it will auto deduct the amount of the staff allocated budget with the course cost and display the latest balance for the staff. let say the staff allocated budget = 1000
staff course cost = 500
balance = 500

how can i do that? any ideas??

thanks<img src=../images/dmxzone/forum/icon_smile_question.gif border=0 align=middle>

have you already built the tables etc so that you can insert into them from the webpage?

Regards

Vince Baker
<strong>DMX Zone Manager</strong>

[VBScript | ASP | HTML | CSS | SQL | Oracle | AS400 | ERP Logic | Hosting]

helo vince,
yes i do have the tables already.
what i did now was i put all the calculation in the updating session,
but it seems so cumbersome..
why i sed this okay..

1. i will register the user to a course
2. before register i need to see the staff budget limit first, and all i can think was to add a form for the user to add more budget if the user budget is not enough for him/her to attend the course
3. then after i have registered the staff later, it should auto deduct the current budget that the user having. but i dont know how to do it automatically and without overwriting the existing total course expense for the user.but i do think that it must something to do with the update statement, but i just can't figure out how.
4. then, if there is an additional cost like the travelling cost spend when user went to the course, the system admin will update it and what i did was, in the editting, i put all the calculation there, so when we update,it will take the correct amount based on the calculation. (seems like cheating to me.. he.. but i dont think this is the correct solution.

so how can i do this? deducting the current budget with the total sum of course(s) attended along with the travelling cost(if any)?

any ideas???