Hi John:
You are correct that I cannot define a unique key based on the combination of Last Name, House Number, and Street Name. I see what you are getting at now. There would be one record in Patron but multiple records in Voter_IDs so it confuses Access.
VoterID in the RegisteredVoters table is unique
I can use the Autonumber primary key from Patrons.
These are the steps you list.
First, I assume VoterID in the RegisteredVoters table is unique.
You also need some unique field (can be an artificial AutoNumber) that you can define as the Primary Key of the Patrons table.
Now put your query in a Continuous Form and be sure the query includes the PatronID AutoNumber field and the VoterID field from the RegisteredVoters table but NOT the VoterID from the Patrons table.
On each row, list the First, Last, House Number, and Street Name fields from both tables.
Add a command button on the row, and behind the Click event of the button, put this bit of code: <code followed>
Questions:
Do I make the query and use that as the basis for the form or are you referring to the construction of the form as the query?
Am I correct that Continuous Form in Access 2007 is just Tabular view?
I am afraid I don't know how or where to add the code for the command button.
I appreciate your help.
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 (3) |
Tidak ada komentar:
Posting Komentar