If you create a view in a database container, you can then

USE MyDBC.View_Items

Then as records are added to the master item table, you can then

select View_Items
requery()

I don't think that what you are trying to do with a direct select statement will work unless you re-issue it over, then you have to worry about the bound controls that may ultimately be using it.