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
|
|||
|
|||
Use a current record to enter new data but keep the old data
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. -- Angela |
#2
|
|||
|
|||
Use a current record to enter new data but keep the old data
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! "Angela" wrote: 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. -- Angela |
#3
|
|||
|
|||
Use a current record to enter new data but keep the old data
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? -- Angela "Kevbro7189" wrote: 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! "Angela" wrote: 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. -- Angela |
#4
|
|||
|
|||
Use a current record to enter new data but keep the old data
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. "Angela" wrote: 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? -- Angela "Kevbro7189" wrote: 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! "Angela" wrote: 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. -- Angela |
#5
|
|||
|
|||
Use a current record to enter new data but keep the old data
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 -- Angela "Kevbro7189" wrote: 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. "Angela" wrote: 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? -- Angela "Kevbro7189" wrote: 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! "Angela" wrote: 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. -- Angela |
#6
|
|||
|
|||
Use a current record to enter new data but keep the old data
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. "Angela" wrote: 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 -- Angela "Kevbro7189" wrote: 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. "Angela" wrote: 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? -- Angela "Kevbro7189" wrote: 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! "Angela" wrote: 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. -- Angela |
#7
|
|||
|
|||
Use a current record to enter new data but keep the old data
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 Kevbro7189 wrote: 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. "Angela" wrote: 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 -- Angela "Kevbro7189" wrote: 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. "Angela" wrote: |
Thread Tools | |
Display Modes | |
|
|