Auto filled shift based on Transaction Timing.

[cap.zadi]

Dears



I need help to solve this issue.

The Shift working timings are 06:00 - 18:00 (Considered Day Shift) whereas from 18:00 - 06:00 (considered night shift).

If the operator open the form "TrnForm" to enter the data so the "Shift" field shall be filled with day or night shift based on timing.

Kindly advise the procedure.

[ranman256]

Make a tShift table, put In the values
Shift, ShiftStart, ShiftEnd
Day, 6:00, 18:00
Night, 18:00, 6:00

Then the user can pick DAY from a combo,and it will fill boxes via the 2 other fields,
either:
(the combo has all 3 fields shown)
txtStartTime= date() & cboBox.column(1)
txtEndTime=date() & cboBox.column(2)

Or run a query to post the same values.