Hi Mike:

I have not been able to accomplish what I want to do is SQL yet, but that is OK. I will get it eventually.

I have been doing some more reading and think I know exactly what I need to do. I believe my question is a lot more precise than last time.

The only problem is the CODING to make it happen.

Here is what I am trying to do:

1. create a stored proceedure in SQL
2. call this newly created stored proceedure from the recordset design time control property box in Interdev.
3. set the paramater once I am there


OK: What I need to learn how to do is write the code for the stored proceedure, to create the paramater I am trying to pass.


Goal:

I simply want to pass the value in my njuris_id field of my jurisdictions ASP/form to my njuris_id field of my country_assign ASP/form. Period.


Can you help me with this code? If so, here are the specifics, and maybe you can show me exactly how you would construct the code.

Example: Let's say I am on the following record in my jurisdiction ASP/form:

njuris_id 17
cjurisname USA
cjuristype Country

I want to click my command button on my parent form and have it open up my child form and have it look like:

suborassign_id 1
njuris_id USA, 17 &&this is where I am trying to pass the variable/parameter. The USA will be displayed, but it will be "reading" the 17.

cjuristype "blank" awaiting input


I just need help contructing this stored proceedure in SQL, to make this happen.
If you can help me with the coding to do this, I would really appreciate it.

thanks Michael.

I appreciate your comments made earlier. After reading the stuff I wrote to you , it didn't come across very clear, so I think I did a much better job asking you what i need in this post..... I hope! I promise I will not ask another question posted directly towards you on this particular issue. I certainly do not want to wear out my welcome on this thread.

tia
jason