AnsweredAssumed Answered

How to update field in employee record based on latest related record?

Question asked by BerkleyKeen on Sep 7, 2017
Latest reply on Sep 7, 2017 by philmodjunk

Background Information:

 

     Employee Table [E_Table] is related to Employee Deduction Table [D_Table]

     Employee Deduction Layout has fields E_Table:employee_id;E_Table:name; D_Table:F_employee_id; D_Table: deduct_type; D_Table: deduct_amount;

     D_Table has multiple records related to E_Table with F_employee_id

 

Question:

 

     How can I show latest record from D_Table on Employee Deduction Layout and use such record in deduction calculations?

Outcomes