Jan-
I would use FirstName, LastName, and ZipCode to do a first cut possible match. You could do a match in a query, but it wouldn't be updatable, so you couldn't directly update the VoterID in the Patrons table.
Consider putting the Patrons records in an outer form, then show the potential First/Last/Zip matches from the Voters table in a subform using the Link Master Fields / Link Child Fields properties of the subform control. You could add a command button to the rows in a continuous subform that when you click would copy the VoterID from the selected record in the subform to the record displayed in the outer form.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 25, 2015, at 11:49 PM, jan.hertzsch@gmail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a table of all registered voters (Voters) from the board of elections and a table of all contacts (Patrons). Not all Patrons live in the precinct and not all are registered to vote. I have added a field to the Patrons table to be populated by the VoterID from the Voters table.
I want to populate that field in Patrons.
I want to compare the tables with a progressively wider net.
FirstName+MiddleName+LastName+HouseNumber+StreetName
FirstName+MiddleName+LastName (Show HouseNumber and StreetName)
LastName+HouseNumber+StreetName (show FirstName and MiddleName)
In my perfect world, it would ask me to pick the match that made sense, I click on it, and the VoterID field is populated in Patrons table.
Am I reaching too far here?
Thanks
__._,_.___
Posted by: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar