>>I've added it many times, just don't know where my data is. It keeps telling me that 'stocknum not found'
>
>Oh, once again, whats the SQL? It sounds like you've got a where clause or a jion statement referencing a field you can't find. You can get the SQL fromt the view designer, the SQL button

My view designer is greyed out.