A separate table would make more work for you. When you need to include both sets you would have to use a UNION query. It might be best to add a bit (Yes/No) field to the existing table to indicate a RegVoter and use a made-up key.
Or what about this? use an AutoNumber as the primary key and keep the Reg ID. That way you can use the Reg ID as an indicator of a registered voter. Make the index on the Reg ID unique and ignore nulls.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
__._,_.___
Posted by: wrmosca@comcast.net
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar