G
Guest
I would like to have a function within my database where the next available
number in a series is automatically found and inserted. For example, I want
to generate a file number, but I can't use Auto Number since I will sometime
insert a batch of info and I think that would mess auto number up. I want
the function to look at 1, 3, 76, 982, and know that the next number it
should pick is 983. Help!!
number in a series is automatically found and inserted. For example, I want
to generate a file number, but I can't use Auto Number since I will sometime
insert a batch of info and I think that would mess auto number up. I want
the function to look at 1, 3, 76, 982, and know that the next number it
should pick is 983. Help!!