Are drop-down menu itmes stored in table?

**Josh Nikle** · Nov 12 '05, 08:21 PM

Re: Are drop-down menu itmes stored in table?

I would definately store that info in a table. Administration is much
easier and so is dealing with the controls themselves.

I actually do something similar on a site and it works well. Just in
case it's applicable, here's what I do there:

1. Two lookup tables, one stores a list of departments and the first
half of a page name, the other stores areas in those departments and
the second half of the page name.

2. The user selects a department.

3. The user selects a work station and clicks Go. At that point, the
first and second half of the page names are combined, and the correct
page is accessed.

This allows me to store a lot less in my tables to access my 300+
pages as I don't have to account for every combination of department
and work area. I don't know if your 1000+ links can be broken down
this way, but I thought I'd throw it out there in case you could use
it. Maybe limiting choices in the second drop-down rather than having
20 different pages to start from? Hope this helps.

-Josh

thinkofanamefas t@aol.com (phil) wrote in message news:<37cae6f0. 0402120751.526e 9f95@posting.go ogle.com>...[color=blue]
> We are developing specs. for a website for a nonprofit org, with
> database for membership related functions.
>
> But..question is regarding drop down menu links. We will have 20
> category-pages, and each page will have 30-50 links- unique to that
> page, so 1000+ total for site- on a drop down menu. Need we assume
> that such links (both plain english description to appear on site, and
> actual URL to link to- so 2 pieces data really for each link(?)) are
> stored in a table on site or in our main database, or are they somehow
> embedded into each menu on individual pages. We will have an admin
> area allowing us to change them in either event, I assume, but we just
> want to know if we must design in storage and search for such link
> info in main database. Either Access or SQL. Thanks.[/color]

**phil** · Nov 12 '05, 08:22 PM

Re: Are drop-down menu itmes stored in table?

Josh, thanks, but we need 20 different pages, each with its own
"identity" and graphics anyway, so we cant have a single drop down(s)
main location that does what you are describing- even if I could think
of a way to combine/create URL info "on the fly". Not sure I can,
since not much overlap of info in the 1000 URLs. I'll assume from your
answer...taking a leap here...that we could do it either way, since
you didnt give a reason not to, other than your application has this
better way? Does that make sense? Anyway, thanks.

**Josh Nikle** · Nov 12 '05, 08:23 PM

Re: Are drop-down menu itmes stored in table?

Phil-

My way's not better, per se, I was just throwing it out there in case
it was applicable and you hadn't thought about it. If you have no
overlap, then my method likely won't work for you. Either way, I
would still store your drop-down choices in a table; it's just easier
down the road as demands for the site change.

-Josh

thinkofanamefas t@aol.com (phil) wrote in message news:<37cae6f0. 0402130739.1588 09fd@posting.go ogle.com>...[color=blue]
> Josh, thanks, but we need 20 different pages, each with its own
> "identity" and graphics anyway, so we cant have a single drop down(s)
> main location that does what you are describing- even if I could think
> of a way to combine/create URL info "on the fly". Not sure I can,
> since not much overlap of info in the 1000 URLs. I'll assume from your
> answer...taking a leap here...that we could do it either way, since
> you didnt give a reason not to, other than your application has this
> better way? Does that make sense? Anyway, thanks.[/color]

Are drop-down menu itmes stored in table?

Are drop-down menu itmes stored in table?

Comment

Comment

Comment