hello one and all, ok, under the DAL model, say i have a county and zip code table, like, as defined as:
db_region.define_table('county', Field('country_id', db_region.country, requires=IS_IN_DB(db_region, db_region.country.id, '%(country)s'), writable=False, readable=False), Field('state_id', db_region.state, requires=IS_IN_DB(db_region, db_region.state.id, '%(state)s'), writable=False, readable=False), Field('county', length=64, requires=NE, comment='county'), ... and db_region.define_table('post', Field('country_id', db_region.country, requires=IS_IN_DB(db_region, db_region.country.id, '%(country)s'), writable=False, readable=False), Field('state_id', db_region.state, requires=IS_IN_DB(db_region, db_region.state.id, '%(state)s'), writable=False, readable=False), Field('county_id', db_region.county, requires=IS_IN_DB(db_region( *db_region.post.state_id==db_region.county.state_id*), db_region.county.id, '%(county)s'), comment='county'), Field('city', length=64, requires=NE, comment='city'), Field('post', length=11, requires=NE, comment='zip or postal code'), see what i am trying to do in the bold? i am trying to limit the counties listed in the subsequent SQLFORM select/options to only those counties that are in the state. when i try to compile i get an error, specifically an AttributeError. any suggestions? thanx in advance, lucas -- 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.