View Full Version : Report across multiple tables


Godfrey2
04-30-2001, 08:39 AM
Hi,
I a currently using Access to basically document some standing/default data that is going to be held in a oracle database.

I have duplicated the tables (about 40) in access and wanted to enter all the default data into them.

(I was trying to think of a way it could re reused by people who do testing etc).

Each table has an extra column called entity_id that links to a entity index table called XXXX_entity_index that hold a description of that entity.

I wanted to have report that printed out all the tables in one swoop with the table description from the index at the top of each table.

Is this possible? It would take me an age to create individual reports for each table. Can anyone think of a better way?