How to use an existing table to update information in a new table

[Miked]

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?

 

[Lynn Trapp]

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

 

[Rick B]

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

 

[Rick B]

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