I'm creating a table for Purchase Order and I start creating formula-numeric field for (PO running number) and to automatically generate starting at 30000 and so on once I add new data. Kindly assist me on this because I don't know where to start in this formula.
Low tech is to simply make a formula-numeric field called [Purchase Order #] which is the Record ID# plus about 30,000.
[Record ID#] + 29990
No doubt you have been testing and have already used up some numbers.
But the way I actually recommend is to take the extra few minutes to determine how many numbers to add, and import say 30000 dummy rows of data using excel,. and then do a list all and the more button to delete them.
That way the [Record ID#] is the PO #.
Thanks for that.
Actually I need to use formula-numeric because I have to use IF function. I have 2 different companies that will use different sets of PO# number.
If [Company]=A, Running Number starts with 30000 and so on, Else [Company]=B, Running number starts with 1000 and so on
Do you think it's possible Mark?
In general, the technique involved using Summary Maximums and snapshot fields. Contact me off line via the information in my profile if would like some consulting assistance to put that in place.
Or rethink how badly you really need to have 2 sequences running. Maybe, in the spirit of KISS you can live with a PO sequence like
A30000, B30001, B30002, A30003.