I need help!!!

[Everton Juniti]

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.

[Wim Decorte]

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.