I am setting up a database for a local political campaign. The campaign gives me names from various sources and I try to match them to the Registered Voter table where I get address and other information. Sometimes, the campaign has the addresses of people who are not on the Voter ID list (ex: People who live outside our three precincts but still donate).
I have been using the voter ID as my foreign key to the CONTACTS table. I could append the non-registered-voters to the Registered Voter Table and make up a new key number (Ex: start with X) but I may want to overwrite the table if I get a new Registered voter list from the Election Board.
Is there a good way to set up a parallel table for these "rogue" addresses? Perhaps a better way of handling it?
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