Hi,
I want to know if it's possible to insert a record to a specific location. For example, I have 4 records with order like this
1 Book
2 Movie
3 Car
4 Laptop
Now, I want to insert a record called Mobile between Movie and Car and it will have order number 3. And the Car and Laptop records will be pushed down and the number will be updated automatically to 4 and 5. It will be
1 Book
2 Movie
3 Mobile
4 Car
5 Laptop
I want to know if it's possible to accomplish this.
Thanks in advance
Duc.