Re: join help: i am lost

2003-01-01 Thread David T-G
-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 sin

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
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, Your scheduling query results, as I said:

Re: join help: i am lost

2003-01-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank -- ...and then Frank Peavy said... % % David, % Just some thoughts.. % See my comments below... Thanks! % % >A scheduling, or a booking, eventually has to have a class type (private % >or one of many groups -- so I suppose I could simply ma

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
David, Just some thoughts.. See my comments below... A scheduling, or a booking, eventually has to have a class type (private or one of many groups -- so I suppose I could simply make a group class type 'private' and that type has only one slot), an instructor, a place, a time slot, and the clien

Re: join help: i am lost

2003-01-01 Thread David T-G
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Frank, et al -- ...and then Frank Peavy said... % % David, % I am unsure if I followed your example completely, but maybe this might % help. Not knowing your complete database structure, I am unsure if my % comments will be entirely valid but here

Re: join help: i am lost

2003-01-01 Thread Frank Peavy
David, I am unsure if I followed your example completely, but maybe this might help. Not knowing your complete database structure, I am unsure if my comments will be entirely valid but here goes. I think you could achieve your goal if you think of your groups as containing one or many clients.