Read up on database normalization. (do a search on your favorite search engine) It will give you an appreciation of storing related pieces of info in different tables. Though you shouldn't need a series of forms to access the data (most of the time) - this has more to do with your programming logic. With a strong understanding of normalization you'll be able to structure your forms to get the info you want.
Here's a great site with examples of different data models. Not all are complete, but a great start and a great source for ideas. http://www.databaseanswers.com/ olinux --- "Apollo (Carmel Entertainment)" <[EMAIL PROTECTED]> wrote: > I have moved our database from Access to MySQL, but > I did leave same structure. > Problem is that in our business we deal with > companies that have multiple > branches so having it like we have now with sub > queries and subforms that have > to look up info from 3 tables to give me one record > of contact information just > does not work anymore. Too many forms with subforms > create huge performance > problems. > Anyone can point me to a good reading material (on > the web or in print) that > would give me ideas how to deal with this > overcomplicated way of handling client > data? > Thanx, > Apolinaras "Apollo" Sinkevicius > Carmel Music & Entertainment, LLC > web-site: http://carmelme.com > ________________________________ > Having an event in Chicago, or would you like to > bring Chicago entertainment > to your event? Give Carmel Music & Entertainment a > call for the finest > entertainment available in Chicago. > > ------------------------------------------------- > Visit CARMEL MUSIC & ENTERTAINMENT website > http://carmelme.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]