I think I figured out what I'm going to do! Spent some time talking it over with Bob T on the phone. It was exceptionally easy to create a report with 2 subreports side by side. Just created 3 temp tables with the data, making sure that part# was the only linking column. Located the 3 tables on my report, created 2 subreports, and located the subreports side by side in the break header. The subreports are smart enough to shrink and expand without stepping on the next row.
My program will process and print the report to a PDF file. I'll create a form that has nothing on it but one big PDF viewer control and the form timer will refresh the PDF every 10 minutes. I know when I display PDFs in the web browser control you cannot "create" a new pdf of the same name because it thinks the file is busy, so in that situation we replaced the url with a "please wait" pdf file, then refreshed with the new copy. Will have to see if the same things happens when displaying thru the PDF viewer. Thanks for tossing ideas around with me, everyone! Karen
