Posted on 2006-11-20
I am using MS SQL 2005 Enterprise Edition and Visual WEB Developer 2005 Express Edition
I have a master student table, SchAppTbl which has a field in it with the row number of a row in the GradeTbl.
I have a foreign key FK_GradeTbl_SchAppTbl established which ties the row number for the student from the SchAppTbl Grade field (4) to the GradeTbl. However, I do not get the description from the row but the row number 4 in the textbox I am trying to populate.
I thought I might have the FK backwards, but the Tables and Columns dialog of the Foreign Key Relationships dialog box will not allow me to do this.
Please Help! Thanks djc916