If I have a Course table and a Student table that are related by Student PK such as (Simplified):



Course1 table which has fields

PK

Course#

StudentPK

TestScore

QuizScore

DailyScore



and Student table has fields

PK

Name



I have a stored procedure that gets the following information using a parameter to get students in Algebra1:

course#,Name and TestScore



I want to put the the above info in a devexpress grid. I can get this far from the help I already got from the forum (I use a dummy table with the correct field names) put the info into a BO and then I use a BBS to attach it to the devgrid. But how does the test scores get back to the course table?



I have simplified the layout of the tables but if we can make this work then I can apply it too the project. TIA

Hi Terry,



Don't really understand the question but what I do need to know is what tables/columns will you be working with?



Cheers, Peter

The data structure is in place from a already purchased piece of software. The company is going to let us access that data and we want to update it outside of their program because of some issues.

I will get the outline of the files and fields together and get back to you. Thanks

Here is the layout:

Course

coursepk

coursename

period



LinkTable

linkpk

coursepk

studentpk

period



The above table has multiple records for each course per period.



Student

studentpk

name



grades

gradepk

studentpk

coursepk

period

positioninperiod

testscore



The grid(s) would have (but is fexible):

coursename,studentname,period,testscore



The only updateable field is the testscore and the data appears in positioninperiod order.