Making Multiple Records Behave as One

[krispi]

Difficult to explain but I'll try:

I have a table containing details of all credit applications placed on our online system (thousands each week). One record = 1 application.

To identify misuse of the system, I then trawl the table to find instances where, for example, forename, surname, postcode are the same, but income is different. I'm OK with this so far.

This is the bit I haven't yet managed:

I need to display these instances on screen, in a continuous subform, one record set at a time, and on the main form for the user to detail the action to be taken (send email or letter, no action, etc) and record the final outcome when a response is received to the email, letter, etc. (decline, proceed, etc)

Any ideas on a starting point?

 

[Remou]

Hi
I used to have to do something much the same with Nurse Registration. The way I had it set up was:
1. Form for Members, used for editting.
2. Subform for query results linked to the main form on what ever criteria I had chosen for matching - used to see the matches / differences.

Have you noticed that sometimes trimming surname, forename fields turns up extra matches?

Reading your post again, I think I may be missing what you are getting at?