Hi List,
Users have requested that transport documents (created in FileMaker) should be numbered in a particular way, eg origin port + destination port + unique serial number, so it could look like FEL/BAR/0001. On each document thereafter, where BAR is the destination port, the number portion would increase by one eg, FEL/BAR/0002 etc. So each destination port would have to have its own sequential number allocation - not sure how to do this, additional/new destination ports are added all the time, so it would have to cope with that. Also, users have (against my advice...) insisted that when a document is cancelled, the number should be released for use again, and it must be used on the very next shipment to that port. So if 0019 was cancelled and 00030 had was the most recent document, then the next document would get 0019, and not 0031. They are presently allocating numbers manually, and looking to me for a solution to their suffering. Any ideas? Regards Peter
