I'm trying to make a relationship, but I don't know how can I do this!!!

I have two tables: One is the Hour table, it contains the following fields:

- Date

- EntranceTime

- LunchTime

- ReturnTime

- ExitTime

The other table is the Employee table, that contais the followin fields:

- EmployeeName

I have to make a relationship with those two tables and make a Layout that I can make a report with the name of an employee (example: Everton) and all his records of the Hour table, that contains the date and time of every worked day.

Please someone help me to do this!!!

Thanks.

You'll need to add an employeeID field to both tables and make a relationship between the two. Why an ID field: because you can have employees with the same name, so don't use names as relational keys in this case.

On the employee layout add a portal that uses the relationship so you can see the time records.