Special Edition Using Access 97, Second Edition

Adding Records to the Personnel Actions Table

Now you can test your work in creating the Personnel Actions table and check whether Access is enforcing referential integrity. The initial entries for each of the nine employees of Northwind Trading are shown in Table 5.7. The entries for paScheduledDate and paEffectiveDate are taken from the HireDate field of the Employees table. The HireDate field of the Employees table now is superfluous because it duplicates the data in the Personnel Actions table. (You delete the HireDate field in a later chapter.) Feel free to be as generous or as parsimonious as you want with the monthly salaries shown in the paAmount field.

Table 5.7. First Nine Entries for the Personnel Actions Table

ID	Type	Initiated By	Scheduled ...