There's already a thread for Maintaining Custom Sort Order but just for one table by @Mike Krailo
What I'm looking for is also the capability to change the order of a field by the user. The attached vba replace the chapter number but when I change the property Indexed to unique values it doesn't work and it detect it as duplicated.
To clarify what vba does:
· Letters are chapters
· Numbers position
· A=1,B=2.C=3,D=4,E=5, then user modifies the A=3 and the rest of titles change to B=1,C=2,A=3,D=4 y E=5
Please find the attached file. It works changing the form ChapterTable, field ChapterOrder.
Thanks!
What I'm looking for is also the capability to change the order of a field by the user. The attached vba replace the chapter number but when I change the property Indexed to unique values it doesn't work and it detect it as duplicated.
To clarify what vba does:
· Letters are chapters
· Numbers position
· A=1,B=2.C=3,D=4,E=5, then user modifies the A=3 and the rest of titles change to B=1,C=2,A=3,D=4 y E=5
Please find the attached file. It works changing the form ChapterTable, field ChapterOrder.
Thanks!