merging 2 tables

H

HaLevi

At first I was writing in to find out how to merge these two tables I have.
Now I am thinking that it would be more expedient if there was a way to
create a new table (#3) that would automatically copy all the fields that I
already have set up in Table #1. Is there an "open as a copy" feature - or I
wouldn't want that? Maybe not "as a copy" but copying all the headings
automatically.
The reason why I thought this might make more sense is because I have a
website based on the Table #1 data, and I don't want to take any chances in
messing up the current site.

W/b - thank you!
 
R

Rick B

Why are you trying to merge two tables? If you create a third, what happens
if you have to update a record in table 1? Will you remember to update
table 3?

Typically, you would never need to merge two tables into one unless you have
a poorly designed database.

Please explain what you currently have and what you are trying to get.
 
H

HaLevi

I have Table 1 that was created as the basis for my data for the website
(selling books) and Table 2 was created as the basis for the printed book
catalog. Table 2 has much less information and was created beacuse we just
needed to get the catalog out and could not take the chance of messing up
site. Now that we have added so much to our inventory and there are more
books in the catalog than online, we want to update the website so that the
customers can see we really have so much more available. Really once things
are streamlined together (I was just making Table 3 as a Draft / Trial
version) then we can get rid of Tables 1 and 2 entirely.
The website has more data than the catalog, although the catalog has more
entries. Eventually all would be brought up to speed. Example, most items
on website have a picture of the book. No pictures are in the catalog. So
for now I need to just show that we have 2000 new titles, and then gradually
we will upload the pics of the books. (Although that is a separate question
- the best way to store these images. Elsewhere, or just as another field in
the database.)
I kind of inherited this business, so I was not there at the ground floor
when the website was initially structured.
Thank you,
 
H

HaLevi

We have a website and a catalog in tables and want to get the items from the
catalog onto the website. So far, we have tried many things and none have
accomplished this goal.
In the website, there is a column named Id which is in autonumber. The
catalog does not have an autonumber column. The website has columns to check
off if an item should appear on the website or not, the catalog does not. Is
there a way to put the catalog data into the website?
 
Top