Payment Number

[ianmuir]

Hi, we have a payment screen for employees. I need to put a field called Payment_number on the screen that increments by 1 every time that particular employee is paid.

This is so I can see how may times each employee has been paid.

a script perhaps?

[TheTominator]

What about putting a calculated field that tallies the number of payments in your Payments table defined as

Count(employee_PAYMENTS::_kp_Payment_id)

EMPLOYEE <-->employee_PAYMENTS

match on _kp_Employee_id