Stored Procedures

Hi..
What I would like to know is that can you search a stored procedure e.g. Searching for a course using a Course code...

The thing is on my data set I made a relationship between 2 procedures "Assessment" and "Teacher"..
"Assessment" is my Parent table and "Teacher" is the child table..

Both are procedures stored in my SQL server
If I dont use procedures and the parent table is a normal table from SQL server, it only searches the parent table but makes an error when I want search the child table..
Can you please tell me what causes this error maybe I might find a solution..

Thanx
J Moloi

Loader.
Up arrow icon