Display Data on report from another table.
I have created a report called "Break Fix Dashboard design" . I also have another table which consists of details of the shifts, includes employee names for each shift ,shift timings and shift date. There are 3 shifts for each day and for each shift two employees will work.Timings for shifts are:
1st shift ( 6 am to 2 pm)
2nd shift ( 2 pm to 10 pm)
3rd shift ( 10 pm to 6 am)
I want to display the names of employees on my report, who are currently working, based on the current time.
For example if the date is Nov 12,2014 and current time is 9 AM, then it has to display the names of employees on my report, who are working at that particular time.
I am very new to FileMaker Pro ,can anyone please explain the procedure clearly.
Thanks in advance,