"Collecting" different fields from different tables to make them table

[cuok]

Hi All!


I have to collect different fields that laying on NON identically structured tables ( BUT All tables have THE SAME "ID" and "DtaeCheck" as PK ) and make of them one table (I already made of those fields).

What I'm doing now –in aim to fill this table- is:
putting a code behind each one of those fields on "AfterUpdat" event that adds those fields to this table.


I'm Wondering if someone can help me with an idea how to do this mission automatically?

THANKS IN ADVANCE

CUOK

 

[THoey]

The problem I see in this is that you are defying the "Normalization" of the database. If you have the data in the other tables, why create a new table with duplicate data in it. If you ever manually change some data in one of the tables, you will have to remember to change it in the duplicate data table also.

Why not just have a query that pulls that data from the different tables? Maybe I am not understanding... Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[cuok]

Hi Terry and many thanks for answering me!

Maybe i had to be more clearer :
sure i'm not 'defying the "Normalization" of the database'

my knowledge in access didn't reaches there!

i have about 28 tables and i need 3-8 fields from each table in aim to send them to excel sheet.
can I make a query "that pulls that data from the different tables" - we are talking about 28 tables!

I will very appreciate more help from you!!

CUOK

 

[THoey]

Yes, that is exactly what you should do. If this was Oracle, you would create a view based on a query of those 28 tables. In Access, I believe you write a query of the 28 tables and then use that query in your export to Excel. Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[cuok]

Thank you very much Terry,

i'll try it tomorrow morning!

thanks
CUOK