We have moved well past associating committees to politician's just because they are a committee's candidate.
How about creating a table with the following form
pupa_id, politician's name, committee_id, reason for control.
which might look like
foo, Ed Burke, 1234, Candidate for Committee
bar, Ed Burke, 4321, Chairman of Committee
baz, Bob Fiorreti, 2314, Candidate for Committee
foobaz, Bob Fiorreti, 3142, Dan tells us so
We have moved well past associating committees to politician's just because they are a committee's candidate.
How about creating a table with the following form
pupa_id, politician's name, committee_id, reason for control.
which might look like
foo, Ed Burke, 1234, Candidate for Committee bar, Ed Burke, 4321, Chairman of Committee baz, Bob Fiorreti, 2314, Candidate for Committee foobaz, Bob Fiorreti, 3142, Dan tells us so