Voter program

[mike]

looking at creating a db for a ballot box to allow teachers to vote on issues
(vs paper). main requirement is the user (a teacher) can only vote once
(need to limit/control access). is it possible to create user accts of some
sort in access?

 

[mike]

could i...have table of teachers, table of voting issues, and table to store
results but only limit each teacher in the list to one entry in the 3rd
table(vs user accts below)...or allow them to write (vote) as many times as
they like but querry report so it shows (counts) same user only once...?

 

[Fred]

Mike,

You're going to have to start with defining your voting procedures and rules
and confidentiality / access / verification rule requirements then design
your database to implement them. Those could make this a lot more
complicated.


But here's a "cart before the horse" structure thought

A table of Teachers, PK = TeacherID
A table of Issues, PK = IssueID

A table of instances of a teacher voting on an issue with at least the
following fields

TeacherID (FK)
IssueID (FK)
Result

And in that last table set it so the combination of the above 2 FK's must be
unique.