Hello Jack, You mean you want to pass the id of the inserted record to another controller ?
# Controller form 1 if form.process(dbio=False).accept: id = db.table.insert(**forms.vars) session.last_record_id = id In the next controller you can access the id you store in session # Controller form 2 session.last_record_id # contains the previous inserted record id Watchout as session will keep last_record_id for the during of it... So you may need to clean it (delete last_record_id from session after second controller complete process) to make sure you are always refering to the proper id... Richard On Sat, Apr 16, 2016 at 2:19 AM, Dave S <snidely....@gmail.com> wrote: > > > On Friday, April 15, 2016 at 9:53:35 PM UTC-7, Jack Lodge wrote: >> >> Im trying to make a Order system for my alevel course work and when im >> filling in some forms i make a *Request* then i redirect the user to the >> *Item_Request* form to fill in the details there, i need to be able to >> get the id of the Request that they just submitted so i can populate the >> Item_Request Table. >> >> I am using Pythonanywhere and web2py >> >> how would i do this? >> > > One way would be for the item form to record in the session the id > returned by its add operation . The order form would then look up that id > in the session. > > /dps > > -- > 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. > -- 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.