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]
