This question is probably very basic but I have been struggling so I'll take the dent to my ego and ask it.

I am writing a program to generate report. I am selecting information from several tables into a temp table and then scanning through that table to do some quantity summarization. While scanning through the table I am summarizing and then writing a single record per 'job' to a second temporary table.

It is the second table that I am trying to use to generate the actual report. When I DO the report form, I get an error message that the first variable name referenced in the frx is not found. However, the variable name is exactly the same as the field name in my second temp table.

So I am thinking that somehow that table is not the currently 'active' table. Does this make sense? How can I 'tie' the second table to the frx correctly so that it is the one that it used to generate the report?

Thanks for any help!!!