macrosoft misleads thousands of people by the way they designed access. in your case, they've confused relations with referential integrity. we cringe when that question hits this list, as it does periodically.
relational databases don't have hard coded relations. NEVER. furthermore, relational database managers should NEVER attempt to enforce such a thing, so of course, mysql does not. the relation of one table to another is a concept which is inherent and subsumed in the very concept and design of a relational database. there are other things that you may need to overcome as you move from access to a server. the people who watch this list are great at helping newcomers but you might also appreciate corereader. it's a free tool at http://corereader.com . check the documentation to see if it has anything for you. > 1 - any way to search archives of MySQL list? > > 2 - In MS Access you have to graphically connect the > table id fields to tell Access how the tables relate. > > How do you do this In MySQL... from the command line > I'm sure... just a code snippit or reference to one > would be nice... > > Thanks for any help - tmb > > > __________________________________________________ > Do you Yahoo!? > U2 on LAUNCH - Exclusive greatest hits videos > http://launch.yahoo.com/u2 > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ --------------------------------------------------------------------- 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
