first stax68, there are only 2 tables involved here.

One table has the accident info.

Info such as the name of caller, name of employee involved in the accident if different from...

thank you David,you are awesome!!!

my sincere apology, I must be losing my mind.

The last part of last post should be:

and use these variables in your insert statement.

how?

sorry, I messed up the last post.

It should look like this:

Do not declare the employee columns as input params to proc but instead declare them as variables

--Declare @address varchar(50)

--Declare @City...

hi David!

One last question, I promise

Do not declare the employee columns as input params to proc but instead declare them as variables

Select the variables from the employee table using @empid

Select...

David,not only are you good, but you are very patient--thank you very much.

I figured out the problem but unfortunately,I couldn't get here fast enough to stop you from thinking.

It was...

I guess it is reaching that annoying stage because what you suggested I just did.

As far as the command object is concerned, I have been using it now for over...

hi David!

Ok, I must be doing something wrong, (surprise!).

Now looking at the two forms below, the first one pulls data dynamically from the db; the other hardcodes the same info...

hi David!

I think your comment about passing id to stored proc is based having viewed the source of the form I gave a link to.

Well, I coded the dropdown to...

hi David!

Thanks again.

Please take a look here:

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

So yes you are right.

The ideal situation would be to pick the names and have all data related to employee automatically...

hi David!

I apologize twice!.

First for just getting your response to my threaded question.

I checked a few times and gave up hope of getting any response.

Second, I apologize for not knowing...

I am sorry tkbr0wn, you are right it worked.

I did a research last night and found an example almost exactly as what you posted now, but one of the sql...

insert into Actions (ActionTypeID,ActionDesc,ActionDate,ActionReport)

select at.ActionTypeID,

@ActionDesc,

@ActionDate,

@ActionReport

FROM ActionType at

I didn't think the above would work and it didn't.

tkbr0wn,

sorry I have already posted a response to amelvin before I saw your post.

Yes what you provided is exactly what I was looking for.

I was just wondering if it would...

Hi I believe I understand what you are saying and I am associating actionTypeID with desc to another table called Spinoff.

the spinoff table also has a prepopulated data.

which looks like...