>>I'm guessing you can't just reference a view in the data environ. like you would with a table.......via objects on the form.........you actually have to programmatically call the view?
>
>Nope, you can add a view to the DE, in the dialog box where it shows you the tables you can add, there should be a View radio button.

I've added it many times, just don't know where my data is. It keeps telling me that 'stocknum not found'