A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I update one table with information from another table?



 
 
Thread Tools Display Modes
  #1  
Old February 4th, 2005, 02:27 PM
FDA
external usenet poster
 
Posts: n/a
Default 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  
Old February 4th, 2005, 03:08 PM
JudithJubilee
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 12:04 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.