I think I'm getting the hang of SQL now. Thanks to all who have answered my questions. I do have one other.
I am an amateur radio operator and radio hobbyist. I have built a database for radio frequency information. Some of the fields in my frequency table include frequency, callsign, agency, etc. I have created other tables with values for things such as agency. Rather than enter "Austin Fire Department" over and over I just have an integer and I can join the tables. Pretty common SQL stuff. How far should I go with this? Right now when I look at my frequency table, it's mostly a list of numbers. I suppose this is more efficient, but difficult (for me) to work with. I'm sure once I have a GUI working, it'll be transparent. My question is at what point should I stop using these lookup tables? Thanks, John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N 97.7851W [EMAIL PROTECTED] http://www.nyx.net/~jmayson --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
