Solved

Foreign Keys

Posted on 2006-11-20
3
236 Views
Last Modified: 2010-04-16
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
Comment
Question by:djc916
3 Comments
 
LVL 16

Accepted Solution

by:
AlexNek earned 500 total points
ID: 17998167
use not row number, please. Use Student id.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question