General information
Title:
Parent and Child tables
Here's my problem:
1. I have two tables a.Students, b. Years. The students table is the parent and the years
table is the child. It is a one-to-many relationship.
2. I'm currently doing a search screen that is based on a grid using a parameterized view for its datasource. The problem that I'm running into is that when the query is run the same students name will come up a number of times and the number is dependent on how many records that student has in the years table.
example Name Schoolname
John Doe John Doe MS
John Doe John Doe HS
3. From the previous example, The name comes from the students table while the schoolname comes from the
years table.
4. What I want is for the students name to come up once and with the name I want their most recent school - in this case with John Doe it would be John Doe HS. Also, in my years table I also store their grade level , which is indexed because I think that this might be the answer to my problem. If anyone can offer any suggestions or help I would be very thankful.
Mark A. Struck
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only