I am using RS2005
I have a query A that returns an order# 123456-0
I have query B that slects out the main order# and returns 123456
I have query C that selects out the backorder# and returns 0
I have query D that then select the order lines based on orderno=b and ordersuf=c
select line# from orders where orderno = b and ordersuf = c.
This returns 3 lines of data as soon as I select the order# (Query A)
If I then mark query B and C as internal or hidden Query D does not run until I click "View Report"
What does the "internal" or "hidden" setting do that makes the query D not run.
I need D run so the user can select which lines he wants and then click "View Report" to do the report on the selected lines.<
View Complete Post