merging tables...

[travismp]

(this is posted in another post, but i thought it worked better here - sorry)

I have 3 tables: tbl_1, tbl_2, tbl_3
All 3 have the same 3 columns: name, email, code

Can I write some vb that can update all the info from these three into one main table called "tbl_MASTER" with the same 3 columns?

Ex:
tbl_1 - 3 records
tbl_2 - 7 records
tbl_3 - 21 records

tbl_MASTER - 31 records. Now the information in the other 3 tables changes everyday so I want it to all be automatic, I dont want to execute 3 different queries or anything like that. Is this doable? Thanks.

Travis

 

[Bat17]

First the lecture
Don't do it keep all the data in one table, look up normalisation.

two answers spring to mind, one, use multiple queries to do the work and call them by code.
or, use a union query to join 1,2,3 together and use that rather than the master table.

HTH

Peter

Peter

 

[john471]

Dual Post

BAT17 - I should have flagged this as a Dual Post when I spotted it, but I forgot about it while I was answering the other post.... Sorry.

 

[travismp]

ya my appologies too. Like I said I posted the other one first, but then thought it might work better here... you can delete this post as a mod. I do not like to cause any waves.

thank you both for the help... working at 3:00am on a project due tomorrow at 8:00 is never fun, but I can always count on you guys. Thanks again.

Travis

 

[Bat17]

No problem

Peter