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
|
|||
|
|||
How to use an existing table to update information in a new table
I have an existing table, that I can't alter. I need the names, and some
other information from that table in a new table which tracks other information. I need the name information to be updated as the old tabel is updated. When one persons name is removed, or added, I want the new table to have that persons name as a new entry. Should I use a query for this? |
#2
|
|||
|
|||
You do NOT need another table. Simply query the information from your
existing table. Any other approach will be a nightmare. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html "Miked" wrote in message ... I have an existing table, that I can't alter. I need the names, and some other information from that table in a new table which tracks other information. I need the name information to be updated as the old tabel is updated. When one persons name is removed, or added, I want the new table to have that persons name as a new entry. Should I use a query for this? |
#3
|
|||
|
|||
As described in your previous post, you would not store the names in more
than one place. Please respond to your original post if you have further questions. Don't post a new thread. If you need an example... you would have two tables... Table1 ------- IdNumber FirstName LastName Phone Address Etc. Table2 ------- IdNumber SomeOtherData SomeMoreData AndEvenMore Linking these by like ID numbers allows you to SEE the customer names in reports, queries, and forms. You DON'T duplicate it in your other table though. As previously explained, what if a name changes? You want to fix both tables? Rick B "Miked" wrote in message ... I have an existing table, that I can't alter. I need the names, and some other information from that table in a new table which tracks other information. I need the name information to be updated as the old tabel is updated. When one persons name is removed, or added, I want the new table to have that persons name as a new entry. Should I use a query for this? |
#4
|
|||
|
|||
Note:
You can also search these newsgroups and read previous posts on this topic. You will find very similar responses in almost every case. Do some research and read up on how a normalized database works. Check out the sample database "Northwinds" that comes with Access. Or, go to the New tab and use one of the templates that deals with data similar to what you are using. There is a contact management template that might be similar to what you want. Rick B "Miked" wrote in message ... I have an existing table, that I can't alter. I need the names, and some other information from that table in a new table which tracks other information. I need the name information to be updated as the old tabel is updated. When one persons name is removed, or added, I want the new table to have that persons name as a new entry. Should I use a query for this? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Update a table with information from another table | Miked | Database Design | 1 | March 31st, 2005 05:59 PM |
Seeking some expert advice. | HD87glide | Using Forms | 14 | March 23rd, 2005 10:11 PM |
How do I update one table with information from another table? | FDA | Database Design | 1 | February 4th, 2005 02:08 PM |
Get data from combo box to popluate the next box | Lin Light | Using Forms | 4 | December 30th, 2004 05:01 PM |