Use a current record to enter new data but keep the old data

  • Thread starter Thread starter Angela
  • Start date Start date
A

Angela

I have a database that holds all of our clients information and I have a few
that have duplicate information except for the file numbers for example. I
need to know if there is a way to pull up that information & use as a
template to start a new file. I have thought about having a separate table
holding the name & address information and then an other one that has the
file numbers. I have also thought about Appending the tabled information but
then I do not know how to pull it back up. Please help.
 
Separate tables, although sometimes a bit confusing, they have the most
flexibility. With multiple tables you can store as many addresses in one
table with a Relation that “points†back to the person’s name. This allows 1
person to have 50 addresses, and another person to have 2. One more benefit
with multiple tables, you don’t have to set up 50 sets of address fields for
that one person when you normally only use 2 to 4 sets.

Use as many tables as possible!
 
OK I agree with you on that one but how do you think it would be best to set
that up? How would I be able to pull that infomration into the form that I
have set up?
 
You can do it a few different ways, it all depends on the amount of data you
have. You could build your new table and copy and paste the information
between the two tables. You could export the information to an Excel file,
manipulate it there and then import it back to your modified Data Base.

If your using Access 2007 under the "Database Tools" tab in the "Analyze"
block there is an "Analyze Table" button. I haven't used this function
before but it suppose to split a table for you. I would make a backup copy
of your DB before you try this.
 
Thats cool I had no idea about that Analyze Table button. Once I do that how
will I be able to link the other information to the stuff in the one table?
Example:

Table 1: Has the address & name (this stays the same)
Table 2: Has the new file number that has to be linked with the address & name
Thanks for your help by the way
 
Well it will step you through the process, you will eventually come to a page
where you will have to drag off the fields you want in the PRIMARY table
(items like name, age, costumer number etc.). Once this is complete and the
Wizard does its MAGICAL Wizard stuff, it should be all linked together.
 
Before you do this. MAKE A BACKUP copy of your database.
Sometimes the Wizard does a good job and sometimes it doesn't.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top