A report based on one particular field from multiple tables

[LeighW]

Hi there,

Everytime a user edits data within the bound forms in the database the approval checkbox (which is a bound field) changes to "False".

Is there a way of creating one sole report based on the records from each table where the approval field is "False"?

This means that I don't require a relationship between the tables it is purely for an approver to come along generate a report and check what has been modified.

Each form is bound to a table.

Form1 = Table1, Form2 = Table2, Form3 = Table3.

The approval field resides in each Table.

Is what I ask possible?

Thanks for any help,

Leigh

[zmbd]

If the tables are related this is fairly straight forward.
However, if not, then two possible ways that I can think of to do this.
You could create a seperate report for each table and then insert these into a parent report. You would then get a single report that groups the records by table.
If you just need to have the data all on combined and pretty then the next option is to try a union query... these can be a hoot and you'll have to have a good understanding of SQL and grouping theory to create the query.
-z

[LeighW]

The tables are related in this kind of format.

Table 1 -> Table 2 -> Table 3

The problem is someone could modify a record from Table 1 and then a couple completely unrelated records in Table 3 so I guess the report would look a bit messy with a record from Table 1 then Table 3 then Table 2, etc.

I think to make it as easy as possible for the approver it would be better if it shows all of the unapproved records from Table 1 THEN from Table 2 THEN from Table 3

From that perspective I'm guessing joining a number of reports into a parent report would be best? I wanted to avoid creating numerous reports for one job but it looks like I'll have to do it that a way.

[zmbd]

From what you've typed, there appears to be no relationships established between the tables. Thus, IMHO, the solution will be the unbound parent report hosting the three subreports.

Please keep in mind however, that this solution is based upon absolutly no information about the structure of the tables or the relationships between them, if any exsist, that might suggest a different way to handle the data.

-z