-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Frank --
...and then Frank Peavy said... % % >Even so, that still doesn't answer the question of how to have data of % >different magnitude in the same table. If I have one class with one % >person and another with two people, how would I have a single record for % >each which lists the client(s)? % % Easy, So you say ;-) % % Your scheduling query results, as I said: % % places, timeslots, personnel, groups, classes % % 5th floor room, 1 to 2, BestInstructor, Local community center, yoga (group % lesson) % 5th floor room, 2 to 3, BestInstructor, Jon Smith "group", yoga (private) % 5th floor room, 5 to 6, BestInstructor, Open Group, yoga (open) % % In order to find out if Jon is scheduled twice, you would need to know if % he is part of the Local community center group. Ahhh... No, it doesn't work that way; a group class is whoever signs up for that time slot that day. Think even non-appointment signin. Well, that may be what you're thinking with the "open group". We need to track who attends, though. Even if we did use this approach, how would we track the group membership? Either we look at the client record and note of which groups Jon is a member, from zero to N, or (probably better) we have a groups table listing the groups and who is a member -- and we're once again back to how to list anything from 1 to N members. Do I just define up to N fields per row and fill in the left-most empty one? Do I stick the IDs in a text field and then parse my way across that field, or can the DB do it? % % Any way.... % You may have to re-think parts of your database structure. A good book on % ERD diagrams might help. Indeed. % % Best of luck. Thanks again & HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, "Science and Health" http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+E1XCGb7uCXufRwARAm1cAKDkppWDoxVj86a12k8uDZaYejiK3ACgrX6d BoUc+3g7mN6Oysyl3ul7Sh4= =QLVn -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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
