I have 2 tables one table references the other table. db.define_table('store_registration', Field('first_name', requires=IS_NOT_EMPTY()), Field('last_name', requires=IS_NOT_EMPTY()), Field('contact_number', label=SPAN('Cell Number'), requires= IS_NOT_EMPTY()), Field('id_number', requires=IS_NOT_EMPTY()), Field('program', requires=IS_NOT_EMPTY()), Field('level_is', label=SPAN('Level'), requires=IS_NOT_EMPTY ()), Field('module_is', label=SPAN('Module'), requires= IS_NOT_EMPTY()), Field('branch', label=SPAN('Branch'), requires=IS_NOT_EMPTY ()), Field('residential_place', label=SPAN('Residence'), requires =IS_NOT_EMPTY()), Field('region', 'reference auth_group', default=get_group(), writable=False), #*Here* Field('recorded_by', 'reference auth_user', default=auth. user_id, writable=False), format="%(first_name)s %(last_name)s" )
db.define_table('temperatures', Field('employee', 'reference store_registration', writable= False), Field('branch', 'reference store_registration', writable= False), Field('temperature', requires=IS_NOT_EMPTY()), Field('ID_No', 'reference store_registration', writable= False), Field('Cell_No', 'reference store_registration', writable= False), Field('residential', 'reference store_registration', writable=False)) I am trying to have the referenced fields pre-populated with their default values in a table form so that I don't have to populate them manually like this: def client_details(): details=db.store_registration(request.args(0, cast=int)) db.temperatures.employee.default=details.id db.temperatures.ID_No.default=details.id_number db.temperatures.Cell_No.default=details.contact_number db.temperatures.branch.default=details.branch db.temperatures.residential.default=details.residential_place form=SQLFORM(db.temperatures) if form.process().accepted: response.flash=T('Temp Recorded') return locals() But this gives me an error: <type 'exceptions.ValueError'> invalid literal for long() with base 10: I read somewhere that this occurs because *reference fields are intended to store the integer record ID's of the referenced records, not copies of string fields from referenced records**.* Is there a way I can achieve my above task without causing this error?! Regards; Mostwanted -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/9d29a0a4-aa4e-421a-b04a-698c5c055840o%40googlegroups.com.