I have 3 tables defined in my model like so: db.define_table('author', Field('name', 'string'), Field('bio', 'text'))
db.define_table('source', Field('name', 'string'), Field('description', 'text')) # a table to store posted Quotes db.define_table('post', Field('body','text',label="Post Body"), Field('posted_on','datetime',readable=False,writable=False), Field('posted_by','reference auth_user',readable=False,writable=False), Field('authorID', db.author), Field('linkID', db.link)) I want to create a form that will allow the users to submit a post using the following inputs: - Post Body (db.post.body) - Author Name (db.author.name) - Link Name (db.link.name) If the author already exists in the database, no record should be created. If the link already exists then no record should be created either. A record should be added to post containing either the newly created or existing IDs for Author and Link. How would I go about doing this? I am extremely new to Web2Py. Thanks for your help! -- 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/groups/opt_out.