Phucon-
Neither. Normally you would put salaries in a separate table to track the salary history of an employee. Primary Key of the EmployeeSalary table would be EmployeeID and EffectiveDate. You would not put a SalaryID in the employees table.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Mar 11, 2014, at 2:37 PM, saigonf7q5@yahoo.com wrote:
Good morning and thank you Mr. Viescas
After removing the fields that belong to other tables, I have tried 2 different ways to link the tables back together. My first tried was, I linked the SalaryInfo table to the EmplInfo table by adding a SalaryID to the EmplInfo table then linked the SalaryID from both tables. The second method was, create a third (bridge?) table and put the SalaryID, SupervisorID… then link the EmplInfo table to the Salary table, Supervisor table... through the bridge table. So far there was no errors occur. However, which method is better or appropriate than the other? Or 1 is wrong and the other is correct.
Thank you
Phucon.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar