i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client.
for this am using familycode a unique code for students of same family .
i use select statment but how i can mention the siblings?
"select familycode,regno,studentname,class from vw_admissionform where regno= '"& txt1.text & "'"
Admission form format is
Student Name :----------------- Class:------------------
Registration No:------------------
Sibilings Name------------------- Class:---------------------