I have this view:

SELECT ClientID, ClientDisplayName, LoginName, ClientEmail,
(SELECT COUNT(*)
FROM qryWorkOrders
WHERE dbo.tblClients.ClientID =
dbo.qryWorkOrders.ClientID) AS TotalWorkOrders,
(SELECT COUNT(*)
FROM qryWorkOrders
WHERE dbo.tblClients.ClientID =
dbo.qryWorkOrders.ClientID AND dbo.qryWorkOrders.IsOpen = 1) AS
OpenWorkOrders,
(SELECT COUNT(*)
FROM qryStations
WHERE dbo.tblClients.ClientID =
dbo.qryStations.ClientID) AS Stations
FROM dbo.tblClients

Only tblClients and qryStations are listed as dependecies, but not
qryWorkOrders. Anyone know why and how I can get qryWorkOrders to be
recognized as a dependency? This and a number of other views have this
problem and it is killing me when I try to copy server objects from my dev
sql server to the production server.

Thanks
Chris