[ |../../index.htm#lansa/reptut01_0065.htm]
You are here:

REP010 - Repository Summary

Objectives

     The table you will create will be called Employee Holidays iiiEmpHolidays (where iii=your initials) with columns based on the following fields:

iiiEmployNumber

Existing employee number field

 

iiiHolCode

Holiday Code

 

iiiHolStartDate

Holiday Start Date

Showtime = False

iiiHolEndDate

Holiday End Date

Showtime = False

iiiHolComments

Holiday Comments

Allow lower case

iiiHolDuration

Holiday Duration (virtual field)

Edit Mask = 2

iiiSurnamePJF

Employee Surname (PJC from the employee table)

 

 |

To achieve these objectives, you will complete the following:
Step 1. Create the Table Definition
Step 2. Modify Field Definitions
Step 3. Add Rules to the Table
Step 4. Create and Execute a Test Form
Step 5. Add a Virtual Column to Your Table
Step 6. Create an Access Route and a Predetermined Join Column (PJC)
Step 7. Recreate the Employee Holidays Form
Step 8. Create an Index and Test
Summary
Some Helpful Tips

[ |../../index.htm#lansa/reptut01_0065.htm]