I have three tables: 1) votes table, 2) ideas table, 3) users table. Each user can vote once for each idea. In order to vote for all ideas, currently users have to add a new record in the vote table for each idea. I would like to present users with a list of all the ideas in the ideas table and allow them to vote for each one without having them add records to the vote table one at a time. If a user has already voted for an idea, his list should reflect his previous vote and he should be able to update it. Any ideas on the best way to accomplish this?
Thank you.
Sincerely,
Douglas