• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 250
  • Last Modified:

Foreign Keys

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
0
djc916
Asked:
djc916
1 Solution
 
AlexNekCommented:
use not row number, please. Use Student id.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now