Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-12-08 : 08:49:34
|
| I need to store a 2 to 3 tier menu in a table. The menu will render drop-down lists in a web application like : FILE, OPEN and FILE, CLOSEKey data to return in the recordset includesMenuItemText, MenuItemURL, .. relationship to parentI imagine a recordset of all the menus to be returned in a single call. The menus will be rendered by ASP or .NET.I'm sure this problem has been solved before. I can conceive of several structures to represent the relationships between rows. Some easier to implement than others. Some easier for the client side than the server side.I'm trolling for suggestions.Sam |
|
|
|
|
|
How to structure drop-down menu data