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.

Reply via email to