Re: Database

Glover George wrote: > There's no way to store this in another table because of the nature of the > program. It reads every table out of the database and constructs a drop > down list (actuall, a list of companies) from the tables so I wouldn't want > it showing the table I am storing this info in. So I would basically have > to create a second database, but that's way too much overhead as I'd be > making too many connections. Not an answer to your question, I just noted you're using a drop down. Drop downs are evil. Have you ever tried selecting countries from a drop down menu? Some sites have about 180 countries listed that way, and getting to select Norway is a dexterity test, especially under Motif based systems (like KDE/Linux), because when getting to the right hand of the screen the menus just appear upon each other. Instead I suggest you use list boxes, that way one can scroll up and down, and it is also possible to hit a key and get to the right position in the list from there. Funny, this weeks Alertbox column also cowers Drop-downs, I just checked: http://www.useit.com/alertbox/20001112.html -- Paul K Egell-Johnsen Developer/PR Manager zez.org: about code http://zez.org/