I am using vb.net to connect to a SQL2000 database.

I want combo box 1 to show departments
I want combo box 2 to show Positions within the department in combo box 1

I can make a dataset with both tables (department, and Position) in it and I can make the relationship between them and I can make the combo boxes work if I use direct SQL queries to populate my data adapters For example:

Me.SqlSelectCommand2.CommandText = "Select pk_Department,Department from department"



The Problem:

I want to use stored procedures to populate the Dataset
so
I have a stored proc that says:

create proc DepartmentList
as
Select pk_Department,Department from department

and I went through the data adapter wizard and connected to that stored procedure.


now when I go into the XSD document for the dataset there are no keys and it will not let me make the relationship.


as I said I know how if I use Ad hoc queries. the XSD shows the primary keys of the tables and I can link things.

When I use a stored proc there arent any keys and when I try "add key" nothing happens.


I do not want to connect to the database using a SQL query only stored procs.

Anyone else have problems with this?

What am i missing?

any help would be greatly appreciated.

thanks in advance

tal mcmahon