Editing non-matching records

John@backacre.co.uk

New member
Local time
Today, 16:59
Joined
Mar 12, 2011
Messages
7
:(I have a problem that my brain can’t sort out and I seek assistance because my deadline is approaching fast. I have a Contact list that has about 800 records and Responses from a web form that is used to determine whether a contact will be coming to a number of planned meetings, (about 200 responses). The two sets of information each contain FirstName, Surname and PostCode so that the Responses can be matched to the right person in the Contact list. However, the responses frequently don’t match due to typos in both lists, so the information received can’t be matched up automatically. (Only about 80% do match). Its easy to find the non-matching responses but a human has to do the reconciliation. To do this, conceptually I imagine 2 forms side by side displaying not just the three matching fields but others too, so the human can edit the data in either list to get them to match on the 3 fields and update other fileds. However I can’t find a way to filter the records so they can be edited. The result of the query that selects Responses that don’t match on the 3 fields is not a dynaset and can’t be edited and I can't find a way to use a filter. The existing Contacts should preferably be filtered as well to minimise the possible choice of match,( e.g. on Surname as they nearly always match), but a manual “find” isn’t too much of a bind.
Ideally, the Responses should be filtered on the form to those that don’t match and be fully editable on all result fields.
I’m using Access 2010 at the moment.

PS. After thinking about the whole process, I planned a better scheme and it works.
 
Last edited:

Users who are viewing this thread

Back
Top Bottom