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 do I update one table with information from another table?
I am working on a data base that will be used to track pay scales. I would
like to have one table that I update annually when the new pay scales comes out, which will, in turn, update the information for the personnel automatically. Any help would be great. |
#2
|
|||
|
|||
Hello there,
This will depend on whether your employees are all on different salaries or if employees are on set payscales. If it is the first option: 1. Create a query based on the Personnel table. 2. Add EmpID, Names, and Salary 3. Save this query. When you want to update their salaries run this query and change their info in this. This will update the table. If it is the second option. 1. You will need a field in the Personnel table that specifies which payscale they are on (PayscaleCode). 2. Create a new table containing 2 fields: PayscaleCode Salary Amount 3. Link this table via the PayscaleCode field to the Personnel table. If the Payscales change you can just adjust this new table. If you want to see what Salary each Employee is on create a table that is based on the two tables and drag Name, Dept, etc. from Personnel and Salary from Payscale Table. Hope this helps Judith -----Original Message----- I am working on a data base that will be used to track pay scales. I would like to have one table that I update annually when the new pay scales comes out, which will, in turn, update the information for the personnel automatically. Any help would be great. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
update queries and forms | Mary Pode | Database Design | 16 | February 2nd, 2005 06:25 PM |
transpose | john | Using Forms | 1 | November 24th, 2004 07:16 PM |
Update one table from another table | Rick Cochran | Database Design | 5 | October 9th, 2004 09:11 PM |
HOW TO UPDATE A TABLE BASED ON CHANGES IN ANOTHER TABLE? | Eva Lyshoel | Database Design | 1 | May 30th, 2004 09:46 PM |
HOW TO UPDATE A TABLE BASED ON CHANGES IN ANOTHER TABLE? | Eva Lyshoel | Using Forms | 1 | May 27th, 2004 11:08 AM |