I have inherited a project with a tight deadline and I am lost for how to proceed.
There are two tables: Canididates and Race. The race table holds 145 different races with information about precincts, winners of different stages of the race (primary, runoff, gneral) The Candidates table has 1100+ candidates, each one is assigned to a specific race via a FK and a list of three race vote totals (general, runoff, primary) I am supposed to create a way to display each race based on a search and then return the candidates associated with that race so that the race vote totals can be updated. I will also need to be able to update values in the Race table. It would be highly preferable for this to be seemless for the data input people. I am looking at producing something like this: Race 1 precincts reporting input - precincts total (static value) Candidate 1 primary vote input - Candidate 1 status (active, eliminated) Candidate 2 primary vote input - Candidate 2 status (active, eliminated) winner of primary (list of candidates) I have most of the form fields and widgets ready to go, but being able to edit multiple entries in two different tables seemless has me stuck. Is this something that I should handle in inlineformsets since I am spanning an FK? Would I need modelformsets to display all of the candidates? I can easily truncate the Race table and change it so that it has a many to many relationship to all of the candidates instead of the Candidates having an FK relationship to the race? Would that give me more flexibility? Thanks for the help in figuring this out, this has been an incredibly stressful project. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
