How do you set up database to capture the Purchase order number?
Can the numbering system be set up so that it is unique?
Thanks

hi,
it depends on the template. if you use an Auto_open ()
macro that sets the number you can record that number in a
text file or another workbook. Better a text file so that
that file does not need to be open like a workbook. Look
up WriteLine in msdn help

- mark


-----Original Message-----
How do you set up database to capture the Purchase order
number?
Can the numbering system be set up so that it is unique?
Thanks
.