J
Jean-Francois Gauthier
Hello,
I need to have a tracking number autogenerate in such a way.
There are three departments:
FIN - Finance Canada
TBS - Treasury Board Secretariat of Canada
PSHRMAC - Public Service Human Resources Agency of Canada
We would like to have a tracking number that would equal a dated stamp from
the paper. The format would be the following.
Department Letter + Financial Year = Sequential Number
Ie. F-07-0000001 then F-07-0000002 etc for FIN doc entered in FY07
T-07-0000001 then T-07-0000002 etc for TBS doc entered in FY07
P-07-0000001 then P-07-00000002 etc for PSHRMAC doc entered in FY07
As explained above we would have 3 stamps, one for FIN, one for TBS, one for
PSHRMAC for each financial year coming and would all have sequential
numbering to them and these woudl be stamped on the paper copies of the
documents. When these documents are logged in the tracking system that I am
building, as they are entered, the tracking number shoudl matched the stamped
number. For this I would have the user pre-select the deparment for which
they are entering info for. If possible I would like to have the F-07
(based on "FIN" being selected, pre-populated in the field, and the autogen
feature do the 1, 2, 3, 4........101 etc.
How hard would it be to do this, and is it even possible?
Would require a response to this ASAP.
Thank you very much for you response,
Sincerely,
Is this doable using one table?
I would have a form where
I need to have a tracking number autogenerate in such a way.
There are three departments:
FIN - Finance Canada
TBS - Treasury Board Secretariat of Canada
PSHRMAC - Public Service Human Resources Agency of Canada
We would like to have a tracking number that would equal a dated stamp from
the paper. The format would be the following.
Department Letter + Financial Year = Sequential Number
Ie. F-07-0000001 then F-07-0000002 etc for FIN doc entered in FY07
T-07-0000001 then T-07-0000002 etc for TBS doc entered in FY07
P-07-0000001 then P-07-00000002 etc for PSHRMAC doc entered in FY07
As explained above we would have 3 stamps, one for FIN, one for TBS, one for
PSHRMAC for each financial year coming and would all have sequential
numbering to them and these woudl be stamped on the paper copies of the
documents. When these documents are logged in the tracking system that I am
building, as they are entered, the tracking number shoudl matched the stamped
number. For this I would have the user pre-select the deparment for which
they are entering info for. If possible I would like to have the F-07
(based on "FIN" being selected, pre-populated in the field, and the autogen
feature do the 1, 2, 3, 4........101 etc.
How hard would it be to do this, and is it even possible?
Would require a response to this ASAP.
Thank you very much for you response,
Sincerely,
Is this doable using one table?
I would have a form where