Menu structure

[Senna]

Hi all,

Wonder how a table design for a menu system that can
support unlimited amount of categories and subcategories
would look like. That is a category can contain
subcategories that can contain subcategories that can
contain subcategories ...


Best regards / Senna

 

[Duane Hookom]

MenuID Autonumber
MenuTitle
ParentID link to MenuID of parent from this table
MenuProcess

 

[Guest]

Hi Duane

Thanks for your answer. The tree first columns I
understand, but what is MenuProcess for. And how should
it be used?

Best regards / Senna

 

[Duane Hookom]

I don't know how you would use it. I might contain a function call or form
to open or whatever. Much like the switchboard functionality in Access.

 

[Senna]

Ok, will look into it. Thanks again for your help.

Best regards / Senna