List of employees that are worked in a proyect

Discussion created by cestebanesteban on Dec 27, 2018
Latest reply on Dec 27, 2018 by cestebanesteban


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:


Table1: Proyects

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?


Thanks again.