Hi everybody! I'm new in this forum and new in vb.net, a beginner. I have a problem, could anyone help me by sending me a code for a multiple update that the data is based on the other table.
I'm using VS 2005 with VB.NET as my language

Here's the scenario:

I have 2 tables, one is table named as “STARTS” with field name avail,uph,yearly_starts.(52*7*24*uph*avail). Other table is named as “THROUGHPUT” with field name process_name,step_yield(%),yearly_throughput.

Uph = 1420
Avail = .8
yearly_starts = (52*7*24*uph*avail)

The scenario of getting the yearly throughput is here:

process_name----step_yield(%)----yearly_throughput
0----------------100--------------9924096-->which is the yearly_starts * step_yield
1----------------99.8-------------9904248-->which is the yearly_throughput of process_name 0 * step_yield
2----------------94---------------9309993-->which is the yearly_throughput of process_name 1 * step_yield
3----------------97---------------9030693-->which is the yearly_throughput of process_name 2 * step_yield
.
.
23 and so on..........................................

I hope that you could help me with this. Thank you so much.

Sincerely,
Jayz