Landlord, according to your situation, I give the following ideas, which may not be correct for your reference:

Class table: dm (system code), user_dm (user code), bjmc (class name).

Student table: xh (student number), user_xh (user student number), bjh (dm field in the associated class table), rxny (school year).

The above is the table structure design, and the class code you show is "user_dm". Your batch update is based on the grade, and the grade is based on the current year-the year of enrollment+1 (for example, September 20 12 is the first grade, and this September will be the second grade). Suppose your students are on the desk.

Suppose w_main in the window has the following controls: dw_ 1 is a combination table of student table and class table (select a. *, b. * from bjb a inner xsb on a. bjh = b.dm). When a button click event is refreshed:

String ls_bjh, ls_rxny.ls_getny

Longdao

int li_nf

ls_getny = string(today()，' YYYY ')

For i = 1 to dw_ 1.rowcount ()

ls _ rxny = dw _ 1 . getitemstring(I，' rxny ')

Li _ NJ =(integer(ls _ getny)-integer(ls _ rxny))* 10

ls _ rxny = string(integer(ls _ rxnj)+Li _ NJ，' ### ')

dw_ 1.getitem(i，' user_dm '，ls_rxny)

then

The above code can be realized, others. DW_ 1 The updated data table is: class table.