Thank you for the "stop" sign. As for the RAD tool I'm open to suggestions, but I think I've read about them all. PHP - MySQL platform.
Stuart --- Peter Brawley <[EMAIL PROTECTED]> wrote: > Stuart, > > >I'm using a RAD > >tool. Meaning it's point and click on fields and > >tables and the code is generated automagically. > The > >one problem I've run into is the RAD tool doesn't > have > >the auto capabilities to allow multiple insert > >transactions into the same table on one "page". To > >allow 5 titles I need 5 pages. From a users > >standpoint, it's not horrible, but not the best. > > >So, now I'm podering a Many to Many, but I realize > >there would need to be multiple Member_Title > tables, > >Member_Title1, Member_Title2, Member_Title3, etc. > > Sounds like a dreadul idea, breaks several > relational rules and will make > more problems down the road &c. Why not lose the RAD > tool, find a better > one? > > PB > > ----- Original Message ----- > From: Stuart Felenstein > To: [EMAIL PROTECTED] > Sent: Friday, August 27, 2004 8:33 AM > Subject: Many to Many: Does this make sense ? > > > I've hit on this subject before but I want to > redefine > and get some feedback. > > Right now I have a table called "Member_Titles" > Members having multiple titles can put them in the > datbases. I allow up to 5 to be held by the user > and > have a count() by ID to test before allowing > insertion. > > Here's my problem. For the web side of things > (and > this is a database related question), I'm using a > RAD > tool. Meaning it's point and click on fields and > tables and the code is generated automagically. > The > one problem I've run into is the RAD tool doesn't > have > the auto capabilities to allow multiple insert > transactions into the same table on one "page". > To > allow 5 titles I need 5 pages. From a users > standpoint, it's not horrible, but not the best. > > So, now I'm podering a Many to Many, but I realize > there would need to be multiple Member_Title > tables, > Member_Title1, Member_Title2, Member_Title3, etc. > > From a join angle, I guess I can live with it, > provided the smoke and mirrors for my users are > there. > My concern is the query part. > With only the one Member_Title table, the search > is > relatively simple, > > "select title from member.title > where title = jerl;" > > from the M2M, > I gather it's going to be > "select title from member.title1,member.title2, > etc > where title = jerk;" > > Anything else I should be considering here and > does it > make sense to change the schema in this way ? > I have 2 other similar forms with one holding 5 > records. > > Thank you, > Stuart > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]