<div>
<div class="content wysiwyg-content">
I am using MS SQL 2005 Enterprise Edition and Visual WEB Developer 2005 Express Edition<br />
I have a master student table, SchAppTbl which has a field in it with the row number of a row in the GradeTbl.<br />
I have a foreign key FK_GradeTbl_SchAppTbl established which ties the row number for the student from the SchAppTbl Grade field (4) &nbsp;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. <br />
<br />
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.<br />
<br />
Please Help! Thanks djc916
</div>
</div>


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

Foreign Keys

Programming includes both the specifics of the language you’re using, like Visual Basic, .NET, Java and others, but also the best practices in user experience and interfaces and the management of projects, version control and development. Other programming topics are related to web and cloud development and system and hardware programming.