Yes Zvjez, but what happens if the user goes to last year just completed and does retrospective data-entry the counter will all go wrong and retro data-entry is a high possibility of happening.

Kind regards
Bhavbhuti

--- In firebird-support@yahoogroups.com, "zvjezdantomicevic" <zvjezdantomicevic@...> wrote:
>
> Do you create new generator for same product every year?
> If so, why not just reset existing generator?
> ALTER SEQUENCE GEN_NR_ID RESTART WITH 0;
>
> --- In firebird-support@yahoogroups.com, Bhavbhuti Nathwani <venussoftop@> wrote:
> >
> > Zvjez, this is an app for a pharmacy drugs manufacturing unit. They need
> > Batch nos. and Control Nos. for their products and raw materials
> > respectively. These nos. are reset every financial year, so for the same
> > product I have a generator for each year, thus running into hundreds every
> > year.
> >
> > Thanks and regards
> > Bhavbhuti
> >
> >
> > [Non-text portions of this message have been removed]
> >
>