Logic to generate unique id -
Create a table in the database named
tbl_id and set the fields (the number of unique id’s to be generated. For
Example – In Computer rental system, there is a need to generate id for both
the customer and the Computer. So, two fields one for the customer and second
for the computer must be set / defined. One thing to make sure is that the data
type of fields must be Number)
Set the default value to 1000.
(Depending on the requirement if the user wants that the id must start from 1
set the default values to 1)
On the form or the web page where unique
need to be generated a select query need to be written in which the field value
from the table tbl_id need to be selected. For Example – In
case of customer id, select the customer_id field value from the table tbl_id
by writing a query like this – SELECT customer_id from tbl_id.
Store the result obtained from this
query in a variable of type integer. Now if the user wants that the id must be
in a suitable format such as CS – 1000, or CUS – 1000 or whatever the format is
just concatenating the prefix required with this variable. (make sure that
concatenation does not change the value of the variable.
On the click of the save button or key
depending on the programming language or the way the action is being performed
update the value of the variable by adding 1 to it and update this variable
value again in the tbl_id customer_id field.
