Hi,
I have sample table with student_id,tch_id and all other fields. For each student we can have one, two, three or maximum of four teacher teaching.
If I have one teacher teaching one student then under "tch_id1", I would like to add that techer id and under "tch_pct1" column I will give .50...