Display on Reports

[rythem]

I have 2 tables with the same kind of data.
The transaction table is for employees who manually enter data and the second is for employees who will use a scanner.

I want to be able to show the information (as it is) from both the tables on the report. Will i need to make a query or can i do this directly.

Thanks
GK

 

[Pat Hartman]

Your application will be easier to develop if your tables are properly normalized. Use a single table rather than two. Add a column to the table that you can use to identify the data source if you need to report on it.