Web forum - FÃ¥ tips og hjelp innen programmering!
Her kan du spørre medlemmene på WebRessurs.no om hjelp innen webprogrammering!
Klikk på et innlegg for å lese / besvare dette, eller klikk HER for nytt innlegg.
Re: Relasjoner mellom tabeller i SQLserver [ Besvar ] Maybe you can try this:
Put all your menu items in one table and relate this table to itself. So
each menu has an ID and a ParentID, that refers to the ID of a parent menu.
Then to get all main level menus you simply do:
select * from tblMenu where ParentID is null
and to get all submenus for a given menu you run:
select * from tblMenu where ParentID = CurrentMenuID
Then you can have arbitrary number of submenu levels, different for each
menu. And a menu on any level can refer to Products table.