Yes, this answers my question exactly. thanks much shawn <div>On 7/27/07, Jamu Kakar <<a href="mailto:jamshed.kakar@canonical.com">jamshed.kakar@canonical.com </a>> wrote:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi Shawn, Note: Please include <a href="mailto:storm@lists.canonical.com"> storm@lists.canonical.com</a> in your responses. shawn bright wrote: > if i have a new object, and i need to know its id, because it is related > to another object, how do i get that id ? I would need to commit(), then > re-select it ? Nope, you don't need to commit for this case.  For the most part, you can just access the attribute and Storm will auto-flush the changes to the database (without actually committing the changes).  For example, the following should work: class Person(Storm):     __storm_table__ = "person"     id = Int(primary_key=True)     name = Unicode(allow_none=False)     def __init__(self, name):         <a href="http://self.name">self.name</a> = name class Account(Storm):     __storm_table__ = "account"     id = Int(primary_key=True)     owner_id = Int()     owner = Reference(owner_id, <a href="http://Person.id">Person.id</a>) # We'll create an Account object and add it to a store. account = store.add(Account()) # Storm's auto-flushing capability with get an ID, if need be. print <a href="http://account.id">account.id</a> # The new person object will be automatically added to the store, by # way of association with the Account. account.owner = Person("Bob") # Again, Storm's auto-flushing will get an ID, if necessary. print <a href="http://account.owner.id">account.owner.id</a> Does this answer your question? Thanks, J. </blockquote></div>