Hi Michael:

Thanks for your reply. I have a question or two. If SQL server doesn't support, parameterized views, how do you go about performing that function?

This is where I am at:

I have built my database in SQL Server. We are using Visual Interdev as the devlopment tool for the graphical interface.

My job on the team is to make sure the guy that is creating the forms has all the SQL statements, views, etc. at his disposal to make things work. Lucky me!!!

We have a parent form called JURISDICTION which fires a child form called COUNTRY_ASSIGNMENT. The assignment form keeps track of each state or province in the specified country.

If the record I am on in the Juridiction table is the following

id = 1
jurisname = AUSTRALIA
type = country

.... i want to click on a cmd. button and fire my child form and have it look like the following>

suborassign id = 1
juris_id && label is "country" = AUSTRALIA
jurisname = stat/province && this one isn't a problem. I can just create a drop down menu that holds each state/province name for the data entry person to select and assign.

the trick is the second field, njuris_id. I want to have Australia automatically thrown into this field when I click on my cmd button to fire the child off the parent.

same goes for the next record. Let's say record #2 is the UNITED STATES. I want the United States to appear in the second field, which is earmarked for the country to be displayed.

I hope I am saying this in a clear enough fashion for you to understand. I was able to do this in FoxPro by placing code in the init event of the child form, code in the default value of the child table. And it worked.

Now, I am drowning!!!!

If you have any advice or input, I would sure love to hear it. If you aren't familiar with Interdev, how would you accomplish this in the enterprise manager of SQL? is that how you would go about it? Or, would you use the front end interface you are accustomed to using?

TIA
Jason