I'm trying to create a way to have a view visible so a certain set of users can see what data needs to be added into a lookup field along with other associated data. So there is no PK to be linked, just need to have what is missing. One thing I'm trying is to have the view returned as a stored procedure table, but I'm getting an error that the SP doesn't exist. This is running under my admin profile so permissions should be an issue, I don't think.
Procedure is called P_Show_vw_Surveys_NewStudent_Band if that helps.
Any suggestions would be helpful.