HELLO ALL
I make a project on clinical lab using c#.net,sql srver 2005
so when a new patient comes he will be registered along with their various tests tests
so at the time of registration the data will save in two tables .
actually i have four tables
1. test master (testid,test name,test rate)
2. referral master (docid,doctor_name)
3. registration_test (regid,test_id);
4. new_registration(regid,patientname,age,sex,docid(FK));
now during insertion data will saved in 4th table(new registration)
and 3rd table (registration_test)
now after sucessful insertion
report which hold current regid(max regid), patient name,sex age,test name,test rate ,doctor name from above four tables
on crystal report
how to do that