I have created a *factory,department,section and team* table in the
database
and a *factory* is on a *one to many* relationship with *department*
a *department* is on a *one to many* relationship with* section*
a *section* is on a *one to many* relationship with* team*
*Table names*
factory = portal_factory
department = portal_department
section = portal_section
team = portal_team
*db.py codes*
## *Factory*
db.define_table('portal_factory',
Field('name', notnull=True , required=True,unique=True)
)
## *Department*
db.define_table('portal_department',
Field('factory_id',db.portal_factory,notnull=True,required=True,requires=IS_IN_DB(db,db.portal_factory.id,'%(name)s')),
Field('name',notnull=True,required=True,unique=True)
)
## *Section*
db.define_table('portal_section',
Field('department_id',db.portal_department,notnull=True,required=True,requires=IS_IN_DB(db,db.portal_department.id,'%(name)s')),
Field('name', notnull=True, required=True, unique=True),
)
## *Team*
db.define_table('portal_team',
Field('section_id',db.portal_section,notnull=True,required=True,requires=IS_IN_DB(db,db.portal_section.id,'%(name)s')),
Field('name', notnull=True, required=True, unique=True),
)
## This is the tricky part
##i want to dynamically make an option list in the *t_department based on
the selected t_factory*
##i want to dynamically make an option list in the* t_section based on the
selected t_department*
##i want to dynamically make an option list in the* t_team based on the
selected t_section*
## Extra fields on auth_user for registration
auth.settings.extra_fields['auth_user']=[
Field('t_factory','reference portal_factory',label='Factory',notnull =
True,required = True,requires=IS_IN_DB(db,
db.portal_factory.id,'%(name)s')),
Field('t_department','reference
portal_department',label='Department',notnull = True,required =
True,requires=IS_IN_DB(db, db.portal_department.id,'%(name)s')),
Field('t_section','reference portal_section',label='Section',notnull =
True,required = True,requires=IS_IN_DB(db,
db.portal_section.id,'%(name)s')),
Field('t_team','reference portal_team',label='Team',notnull = True,required
= True,requires=IS_IN_DB(db, db.portal_team.id,'%(name)s')),
]
i have an attached file where this what i want to happen upon registration
Upon registration if i select *factory* *A *there are different *department
*selections in the dropdown (dropdown.png)
same as if i select *factory B *there are different *department *selections
in the dropdown (dropdown2.png)
this setup will just follow for *department *to *section *and *section *to
*team*
Thank you in advance for your help...More power to web2py
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
