I need to do a Crew List - PDF report with the employees that are worked in a proyect.
Name of the employee ---- department ---- email ------ phone
I have a database with this structure:
related by proyect name with table 2
Table2: Start Forms (it is possible that one employee have worked in different periods of time)
Related by employee name with table 3.
Table3: Employees (with the personal info - email& phone)
I can do a Crew List report from Start Forms table2 with this info but in the found appear duplicate names of employees because this employees worked in diferents periods and have two or more records.
¿How can I found only UNIQUE records (by name) in the Table2?