>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

Don't include 'Name' field in your view definition, instead of this add label with caption refreshed each time when you move pointer in 'Students' table by View1.Schoolname value.