I need to create a view with an index field. I know that in order to do this the view must be schemabound. The view i am trying to create is based on another view. When i try to create the schema bound view however i get an error message saying that the base view is not schemabound. Unfortunately, the base view is created by a 3rd party application so i don't want to mess with that too much. Is there a way to create a schemabound view based on a table or view that is not schemabound itself.
Error output below.
Cannot schema bind view 'ContactsByProjectID'. 'dbo.A_PROJECTID' is not schema bound.