[web2py] Re: invalid literal for long() with base 10: when linking 2 tables

Hi, I think you'd better reference your store_registration table once by id in the temperature table. Field('store_registration_id', 'reference store_registration', writable= False), In that way you comply with the rule of single_point-of_definition. The way you define your temperatures

[web2py] Re: invalid literal for long() with base 10: when linking 2 tables

Hey Dave thanks for replying. I think i'm going about this the wrong way. The *temperature *table already references the *store_registration *table via the *employee *variable. By my understanding the *employee *variable already holds all the information in the *store_registration *table & I

[web2py] Re: invalid literal for long() with base 10: when linking 2 tables

On Thursday, June 11, 2020 at 8:55:16 AM UTC-7, mostwanted wrote: > > 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()), >