In my database I have blanket orders whereby a customer can order a large sum of goods and release them as needed. Whenever they call to release an amount of their goods, my database generates a call out form to send to shipping to pull the goods from the shelf. Each call out form should be given a release number from that particular order as there may be 20 releases off one order, i.e. Order No. 10001 should have release 1, 2, 3, 4 etc. My question is how do I make the release unique to only that one order. I want the release number to generate auto although it will be manually keyed on the packing list. Anyone who can help me with this, thank you very much.

Hi,

My suggestion is an auto-enter calculation of the sort:

OrderNo & "-" & (PreviousReleaseNo +1) so that the result would be

10001-1

10001-2 etc.

Hi,

Sorry had a look at that and realized it wasn't very clear (weekend must be coming...). Anyway, PreviousReleaseNo, means the value held in the field ReleaseNo. on the previous record. To do this, every time a release record is created it's release number is posted to a global field (for our purposes, Scrap). The calculation then becomes:

OrderNo & "-" & (Scrap +1)

Hope this helps!