Merging tables?

richy1

New member
Local time
Today, 05:15
Joined
Nov 14, 2007
Messages
6
Hi all :) I have 22 tables in my Access database, which is my catalogue data. I have it set up on dreamweaver. Now tho, i need a search engine going thro it, i have a script in access/dreamweaver that works. Only thing is, that the script only works thro one table. Now, is there some way to merge tables into one? Not just copy and paste, but all have the same specific name that i maybe able to link? (ie Name, description, code) Any ideas? A tutorial link would be great if anyone has come across a similar thing, thx!
 
Try reading up on Append queries. This should let you merge your tables.
 

Users who are viewing this thread

Back
Top Bottom