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?
------------------------------------------------------------------------------
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.
