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: jan.hertzsch@gmail.com
Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar