If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
merging 2 tables
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! -- knuble07 |
#2
|
|||
|
|||
merging 2 tables
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. -- Rick B "HaLevi" wrote in message news 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! -- knuble07 |
#3
|
|||
|
|||
merging 2 tables
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, -- knuble07 "Rick B" wrote: 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. -- Rick B "HaLevi" wrote in message news 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! -- knuble07 |
#4
|
|||
|
|||
merging 2 tables
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? -- knuble07 "HaLevi" wrote: 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! -- knuble07 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Relationships set up | linronamy | New Users | 7 | February 20th, 2006 10:45 PM |
merging multiple pivot tables | L Aichler | Worksheet Functions | 0 | November 18th, 2004 10:31 PM |
Mutliple Tables lookup? | Westley | Database Design | 4 | June 15th, 2004 01:07 AM |
Mail merging in tables | Tutu | Mailmerge | 1 | May 26th, 2004 07:44 AM |
Merging several tables onto one form | Nikki | New Users | 2 | May 10th, 2004 01:55 PM |