Update different table from form

[N7925Y]

I have a table called "voters" that has all the voters from the district. I have another table called "contacts" that is where everyone who calls into the office is entered. What i want to do is search the "voters" table to find someone when they call and then add them to my contacts table. Tried doing this through a form but no luck. Any ideas?

[davegri]

More things to consider:

Does a contact have to be a voter?
What happens if a voter calls more than once? Is another contact added for each call?
Why can't the contact information be included in the voter table, thus eliminating the contact table? (only if one voter = 1 contact)
What additional data fields are needed for the contact record?

[NTC]

You don't want two tables with a name/ID. Consider your Voters table as the parent table and make your Contact table the child table that records the contents of each contact i.e. date time topic etc.

Then make 1 form out of them - have the Voter table be the record source of the main form and insert the Contact form as a sub form into it.