In message <b3u2h8+49g1@...>, duilio_fos <irel_llc@...>
<irel_llc@...> writes

>Every company must know the no of its pictures (the application will
>issue a "select count(*)..") and nothing else.
>
>All in all I stay with the idea that I need one generator for every
>company: I see no other solution.

Why not a new table with a field for company ID, and a field for "next
available number for this company"?

>
>Thank you
>
>Duilio

--
Pete Clark

NO TO WAR
No more terrorism - Arabic, American, or British