Michael and Vinicius,
I think Byron's response to Michael's post was correct:
Your database design is not good. Read up on normalization.
Vinicius' table should have one record for each course number.
Michael's table should have one record for each category.
-David
On Fri, 14 Apr 2000 09:04:12 -0700 "Michael Blair" <[EMAIL PROTECTED]>
writes:
> I had a post with the same problem! Anyone out there willing to
> knock off 2 birds with one stone?
>
> -----Original Message-----
> From: Vinicius Caldeira Carvalho [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 14, 2000 5:48 AM
> To: Cftalk
> Subject: DB Problem
>
> Hi there!
> Im working on a project for my boss, it consists in a form where
> users can
> subscribe to some courses. Well my problem is ...
>
> In the main table I have a column that links to another (the course
> is a
> number that links to a table showing the names). Ok, My boss asked
> me to
> peform some verifications when the user try to subscribe (like if
> the user
> is already in the DB, we only add another type or course for him.)
> Well what happens now, my course column can't be a number anymore,
> cause I
> want to be a list
> 101,103,107 (and it goes for as manny courses as the user chooses)
> untill
> know ok. Problem is when creating a report page My SQL looks like
> these
>
> SELECT (fieldnames)
> FROM Main, Courses
> WHERE Main.Course = Course.CourseName
>
> Well It'll just don't work once my course column is a list. I tried
> IN
> operator but it didn't work either, what shoud I do?
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
