Say I had information about a subject on 1 table with sub-id as PK.

Say on another table I had a list of students stud_id and subjects sub_id with combined PK. The sub_id can be repeated of course as it is only part of the key.

I change the sub_id on master table and then i need to change on l save table. Say this is the cse for argument sake.

I have a subject information in textboxes single record and a datagrid for each subject/student entry.