Implementation of dynamic ranking for a colummn in an individual table


I have various tables in which each record has an associate rank. The rank given is not an automatic, calculated rank but a manual rank decided by me.

I want the rank to be dynamic so that if I add a new row which should be ranked somewhere in the middle of the total order then all other entries in the same table have their rank change accordingly.

I do not need the rank to taken into account any other tables, the rank is specific to each table individually.

Is this possible?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.