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