hozo
May 16th, 2000, 12:54 AM
Hey guys:
I'm working on a trouble ticket system for my company and basically I'm using a long auto-assigned primary key for the ticket number. What I want if for the staff to enter in the ticket information. Once they click APPLY.. I use the updatebatch proc. to update, however the Record/Ticket number field does not update. If I try to assign the field it's own value with absoluteposition, the DAO gets saucey and doesn't let me change it (being auto assigned). If I do a requery, I lose the position. I gues my question is how do I make the database refresh right to the record they just created. I'm sure this is easy, but I'm new to db's. Thanks guys (and gals!)
I'm working on a trouble ticket system for my company and basically I'm using a long auto-assigned primary key for the ticket number. What I want if for the staff to enter in the ticket information. Once they click APPLY.. I use the updatebatch proc. to update, however the Record/Ticket number field does not update. If I try to assign the field it's own value with absoluteposition, the DAO gets saucey and doesn't let me change it (being auto assigned). If I do a requery, I lose the position. I gues my question is how do I make the database refresh right to the record they just created. I'm sure this is easy, but I'm new to db's. Thanks guys (and gals!)