This problem won't go away.

I have been trying to fix the asp part of this code (please read the problems I have been having in prior posts) but it is...

great stuff swjs!

Your code will certainly be a great help.

I will post again if questions arise out it.

great stuff swjs!

Your code will certainly be a great help.

I will post again if questions arise out it.

hi!

Hope you have fully recoverd from your guiness infusion.

I truly understand and agree with everything you have said so far but just a few things and if they make sense...

Thanks to all of you who have shown interest in helping me get through this.

Here is where my biggest need and biggest problem lie right now.

I have a total of...

hi whoteegan!

I think it is more complicated than that.

Sorry I didn't let you guys in in all of the tables involved.

The witness table relates to the accident main table. So...

I forgot to mention that I do have the insert statement to work right now.

I used a crude (spagetti) method of inserting records but it seems to work.

What I would...

hi David, again!

If you have time, can you give me an example of what you just said, especially as it relates to displaying the witness/passenger records?

Thanks as always.

hi whoteegan, and swjs!

I appreciate all the input.

Right now, I am more concerned about getting the form to store data for all those fields on the database.

I am close to...

Man, for a site owner, you are very generous and kind.

I will try the 5 inserts first.

Like I said earlier, my primary objective is to be able to write the...

Thanks a lot again, Andy!

I am posting a link to my staging area.

This link provides a bit of a visual clue to what I am looking to accomplish:

http://www26.brinkster.com/simflex/kenig/accident_Report.asp

If...

Andy, thanks for the response.

I agree with with you that no limits should be set on the number of witnesses, though that was the client's spec, I think I can...

I think I am beginning to narrow down where the problem is coming from myself, thanks in large part to you.

I am using a fron end tool (ASP) to do...

thanks again David!

Table tblprojecttasks has the following:

projecttaskid int pk identity,

statusID int --foreign key from status table,

taskid int -- foreign key from task table,

project_id int -- foreign key from project table.

As...

hi David, good to hear from you again!

Recall that the stored proc is intended to associate tasks to a project based on project type.

Recall also by looking at the attached...