Versions Compared

Old Version 2

changes.mady.by.user Nicolas Rios

Saved on

compared with

New Version Current

changes.mady.by.user Fabiola Arias Navia

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

1.  Create a field for the employee surname to be used as a PJC as follows.

Field Name

Field Description

Type

Length


iiiSurnamePJC

Employee Surname

Alpha

25

Allow LC

 
2.  Define an Access Route to the Employee table, with a key of iiiEmployNumber.

3.  Define the Predetermined Join Column to retrieve iiiSurnamePJC from the employee surname (iiiSurname) in the Employee table. This is a lookup PJC.

...