I found my big Duh! While I did add the sub report table (view) in the Add/Remove table screen and I had all my column names in the subreport assigned to the correct table/view....
I did not assign the view name to the sub-report in the table name box! I do not not how many times I must have looked at the main report screen and when the sub report tab stated : "SubReport: table not assigned" my mind simply did not register it! I simply clicked the drop down box and selected the view and all is well! Oh well.... another cannot see the forest for the trees ... Thanks all, -Bob -- Thompson Technology Consultants LaPorte, IN 46350 219-363-7441 -------------- Original message -------------- From: Lawrence Lustig <[email protected]> << Yes, the view shows all records desired via a select statement for MO_Number = .vMO >> The view should not limit the MO_Numbers (that will still be taken care of by the automatic join performed in the report). The view should limit the sub-records by _date_. -- Larry
