Now that I have this temporary view working, below is how I want to use it.
I have a report based on a view that gives me all the costs associated with the products the company makes. This works fine for most of our products. On our larger products however, I need to insert the labor into the report by adding the total hours to assemble a specific model. Each model is different based on the "add ons" the customer wants so the labor to assembly that model is "job specific". So what I want is to keep the existing report structure that gives me the material and labor for the parts associated with this model and then at the end go to the WORKINFO table and insert the hours for the assembly of that model. Would the best approach be to create a temporary table or view to insert the specific info into? (That is what I just did with the view you folks helped me with) If that is the case then I would need to know how best to put that into the report. I assume I would need to create an EEP within the report for this task. I have never run reports off temporary tables though I have created temporary tables & views within a command file. Jim
