How to find two tables in the name and date of birth of students?-CodePudding

Because the work needs, find two tables in the name and date of birth of students?
Graduates always watch is always
The table is the student table
I made a form, but a little problem, is the only name consistent with the students to find, how to carry on the date of birth to match?
Next on how to modify the code?

 local a, b, I, num 
1 
 seleB=thisform. Text1. Value 
Use & amp; B alias bb 


Sele 2 
A=thisform. Text2. Value 
Use & amp; A alias aa 


I=0 
J=0 
Sele 2 
The do while. Not. Eof () 
Ly=xm 
1 
 seleLocate the for xm=ly 
If found () 
Repl bb. The serial number with ALLTRIM (bb) serial number) + ', '+ ALLTRIM (aa) serial number) 
I=I + 1 
The CONTINUE 
The else 
Sele 2 
Repl marked with 'no' 

J=j + 1 
Endif 
Sele 2 
The skip 
Enddo 
1 
 seleUse the 
Sele 2 
Use the 
? I

CodePudding user response:

 local a, b, I, num 
1 
 seleB=thisform. Text1. Value 
Use & amp; B alias bb 


Sele 2 
A=thisform. Text2. Value 
Use & amp; A alias aa 


I=0 
J=0 
Sele 2 
The do while. Not. Eof () 
Ly=xm 
1 
 seleLocate the for xm=ly 
If found () 
If bb. CSRQ==aa. CSRQ 
Repl bb. The serial number with ALLTRIM (bb) serial number) + ', '+ ALLTRIM (aa) serial number) 
I=I + 1 
The else 
The CONTINUE 
Endif 
The else 
Sele 2 
Repl marked with 'no' 

J=j + 1 
Endif 
Sele 2 
The skip 
Enddo 
1 
 seleUse the 
Sele 2 
Use the 
? I

I to add some, but I don't know why like some graduate students have multiple overlapping names in the table than don't come out
They could not in the student table and mark