>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
Mark, does your Years table have a date or anything else that can be used to rank them in chronological order? If so, you can use max(year.year). in your table and group by the student name.
Barbara