Hi all,
I have a question about whats the best way to keep track of a records number. I am probably going to phrase this poorly, so thanks for sticking with me.
Lets say I have 5 records. I insert them to a table and one of the columns in my table is a record number, so values in this case will be 1,2,3,4, and 5. If I want to delete record 3 and make record 4 -> record 3 and record 5-> record 4, is there an easy way to do this?
Or is there a way if I know I have a table with 5 records in it to get say the 2nd or 3rd record?
Thanks in advance.
I have a question about whats the best way to keep track of a records number. I am probably going to phrase this poorly, so thanks for sticking with me.
Lets say I have 5 records. I insert them to a table and one of the columns in my table is a record number, so values in this case will be 1,2,3,4, and 5. If I want to delete record 3 and make record 4 -> record 3 and record 5-> record 4, is there an easy way to do this?
Or is there a way if I know I have a table with 5 records in it to get say the 2nd or 3rd record?
Thanks in advance.