Hi All,
I'm making a website for elections,
so i have table for Governorates definition, then region definition
related to Governorate
also i created a table for nominees which is related to each region
and each region can have more than one nominee.
also i have a table for voters who is living in a chosen region, and
he should choose a nominee which is related only to these region.
my table like:
db.define_table('Voters', Field('name', label = 'Full Name'),
Field('national_id', label ='National ID', unique= True, length
=14),
Field('email', label ='Email Address'),
Field('region_id', db.Regions,label ='Region'),
Field('Nominee_id', db.Nominees, label ='Nominee Name'))
i want to create a form for adding new voter and in this form he can
choose his nominee based on his living region. so i want the form to
automatically show the governorates list, the regions list based on
selected governorate, then show the nominees list based on selected
region.
is there any solution for this.
thank you
