>
>The answer to your question is no. But in this case it would be best to use an event object to coordinate the two objects. Read the documentation on event objects.
I thought about using an Event object but there really isn't much "coordinating" that needs to be done. The object calling this method may not be the same one - I didn't want to complicate the situation.
As far as using NewID(), I decided against it. The hitch was that the invoice number changes depending on which location the user logs in from. Handling this through another object just seemed to be the cleanest way of doing this. I have to make sure this app. can be moved to MSDE, and eventually all the info. consolidated on SQL server so I want to avoid putting too much code in the database.
Thanks for the info.