bunu sınırsız sayıda dallanabilen menü haline nasıl getirebiliriz
Kod:
SELECT MenuItems.MnsId, MenuItems.MnsDesc, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems WHERE (((MenuItems.Level)=1)) UNION ALL SELECT MenuItems.MnsId, " :..... " & MenuItems.MnsDesc, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems WHERE (((MenuItems.Level)=2) AND ((MenuItems.CurrentState)=1)) UNION ALL SELECT MenuItems.MnsId, " :..... " & [MenuItems].[MnsDesc] AS Expr1, MenuItems.SortKey, MenuItems.ActionType, MenuItems.CodeToRun FROM MenuItems AS MenuItems_1 INNER JOIN MenuItems ON MenuItems_1.MnsId = MenuItems.SubId WHERE (((MenuItems.Level)=3) AND ((MenuItems.CurrentState)=1) AND ((MenuItems_1.CurrentState)=1))
ORDER BY MenuItems.SortKey;şimdiye kadar gördüğüm basit ama en kullanışlı menu oldu
tek eksiği 3 level için olması
