>At first it may seem bad to have to wait until the update and read to get the id. In a accounting package I did, before clearing the screen after a commit, I would give a message back with the ID number so they could write it on the hard copy for reference. They soon get used to it and actually prefer that to burnning up numbers.
>
>hth
>Mike D
Unfortunatly we had it that way and they asked us to change it!! We questioned it but they didn't like the fact that they had an extra mouse click on msg box to display the Journal #. Go figure - big clicks get what they want. <g>
anyways were back to the drawing board...Maybe we will get Sql to do the processing and VFP to update the Journal #'s after they have been locked to this serires of entries.
Thanks again
Shawn