M
manish
dear all
i have a database which stores the estimates and bill
details. first the estimates are raised and if approved
the bills are finally raised after say a gap of 15 days.
there are two fields one estimate-no and the other invoice-
no but both are as a text field.
the numbering is done as follows
0403/01 - the first two digits mean the year the next two
the month of the year and finally the last two mean the no
of the estimate or the invoice in the particular month.
however there is again a different type of invoice-no
which is as follows
D-0403/08 - here "D" stands for debit note.
my question is how can i display the last estimate-no,
last invoice-no, and last Debit-note no raised on my FORM
so that when an estimate is raised i can type in the next
bill-no without first sorting it and then finding the
latest no.
urgent help required please.
--manish
i have a database which stores the estimates and bill
details. first the estimates are raised and if approved
the bills are finally raised after say a gap of 15 days.
there are two fields one estimate-no and the other invoice-
no but both are as a text field.
the numbering is done as follows
0403/01 - the first two digits mean the year the next two
the month of the year and finally the last two mean the no
of the estimate or the invoice in the particular month.
however there is again a different type of invoice-no
which is as follows
D-0403/08 - here "D" stands for debit note.
my question is how can i display the last estimate-no,
last invoice-no, and last Debit-note no raised on my FORM
so that when an estimate is raised i can type in the next
bill-no without first sorting it and then finding the
latest no.
urgent help required please.
--manish