4 messages in com.mysql.lists.gui-toolsRe: newbie needs table sharing advice| From | Sent On | Attachments |
|---|---|---|
| Troy T. Hall | 28 Nov 2003 22:09 | |
| Adam Hooper | 29 Nov 2003 07:15 | |
| Nick Sloan | 29 Nov 2003 12:47 | |
| Troy T. Hall | 29 Nov 2003 12:52 |
| Subject: | Re: newbie needs table sharing advice |
|---|---|
| From: | Nick Sloan (nslo...@comcast.net) |
| Date: | 11/29/2003 12:47:44 PM |
| List: | com.mysql.lists.gui-tools |
As an old hand (I have been here two weeks) I can tell you this is the only place that I know of to get any "HELP". There are no help files with MySQLCC and the MySQL manual hardly mentions the GUI. I personally don;t like operating at the command line and I find MySQLCC to be a potentially great tool. Unfortunately WRT to the F1 key - since there are no HELP files it is useless. The "what's this" operates in some places.
While SQL management does not seem to look at this forum there are some very knowledgeable people who do and you may get an answer to your other question within a day or so.
Regards Nick Sloan Also searching in the wilderness.
____________________________________________________________________________
_______________
----- Original Message ----- From: "Troy T. Hall" <tro...@classicnet.net> To: <mysq...@lists.mysql.com> Sent: Saturday, November 29, 2003 1:09 AM Subject: newbie needs table sharing advice
Hello, I'm brand new to MySQL and MySQLCC. I've been able to create the database and tables just fine, but I have the need to have Fields that occur in one table also show up in other tables. For example : Mary has 1 route John has 2 route Phyliss has 3 routes. I have a table within database a that has a address book of all carriers. I have another table that has a list of all routes. No two carriers can have the same route, but a carrier my have more then one route. I want the carrier table to contain all of the routes that this carrier has and the route table to know if the route is taken by a particular carrier so that when the carrier is terminated the route available date field will populate. Or when the route available date is non-null then it is available. Any guidance on this will be appreciated.
Troy I tried the F1 help function but its greyed out.