make sure ur data types in your web page match the ones in your database.

I would be able to help you further if tell me what application ur using to...

Thanks, I'll apply that and see if it works.

thanks again.

I could use a stored procedure, but I dont know how i would code it, Im still a beginner at sql, so any help would be greatly appreciated

Thanks..I manages to get it working by using the insert into statements all at once, that eliminated all the nulls. I got another problem though. You guys will probably find...

Thanks for you input.

The schedule table consists of columns that are identical to columns from several other tables.

trainers.trainerID..........schedule.trainerID

students.studentID.......schedule.studentID

class.classID................schedule.classid

branches.branchID........schedule.branchID

course.courseID...........schedule.courseID

Since I have entered values into the columns of the tables (trainers,students etc)

I...

Thanks your suggestions. I've began to implement them.

The branches table will not be modified much if at all, there probably only be about 30 - 50 entries into that table. When ...

attn: Grasshopper, here are the scripts for the 2 tables.

Branches:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_schedule_branches]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)

ALTER TABLE [dbo].[schedule] DROP CONSTRAINT FK_schedule_branches

GO

if exists...

Thanks for your contribution grasshopper.

Let me explain a few things about my database.

the database is going to be used as a scheduling sysyem for a collge that has branches...

attn: Enthusiast

Your solution works fine, however when I try insert in other columns from the class table, I get an error message saying:

Cannot insert the value NULL into column 'branchID'

but...

Thanks, Your a super star. I can see where my code was wrong. Thanks again you saved me a lot of time