How can i do this? Read List View and Filter another List view based on entries?

Hi,

Any ideas on how best to do this?

I have 1 Form and 2 List views.

List View 1 is based on criteria such as bring back all Scheme Numbers within a date range.

So the results could be as follows:

Scheme ID              Scheme Name

1                               Tester

3                               Live

List View 2 has a bunch of user detail fields and also a Scheme ID:

Scheme ID            User Name

1                              Bruce Lee

2                              Jackie Chan

2                              Mighty Mouse

3                              Mr Bean

So the end result in List View 2 must be as follows:

Scheme ID            User Name

1                              Bruce Lee

3                              Mr Bean

Any ideas how i do this? Is a loop needed to read the first Scheme ID from List View 1 and then Loop again for more.

Thanks