One to Many Relation

[#1]

Hi All,

Need Help...!!

I Have a project table which contains the project id and project owner info. and 1 more table called utilization table which contains employees who wrked on the project,project ID and utilization hours. there are cases like the owners can work n the same project.

Both are connected based on PROJECT ID.

Now i need to make a Table for utilization hours where OwnerName=EMployeeName. the issue is tht when i select an owner it has been related to more than 1 employees. How can i achieve this.

Thanks In Advance..

Reena

[robert_mika]

Could you post sample of your data?

[petter]

Something like this might work for you. The Employees table is connected to the Projects table via Utilizations. So for any employee associated with a project there has to be an entry in the utilizations table. For instance an owner can have one entry as an employee by filling in U.Role with 'Owner' and if the same person also contributes as a billable resource the U.Role could be set as 'Team-member'. This way you could filter on U.Role or use it in context with name to  clarify that Carla is participating both as an owner and as a team-member ... two roles - one person.

I have attached a sample too to give you some idea on how this can work.

Another approach could be that you in fact have one table for all employees that participate as regular project member in projects and a smaller table with all the employees that are owners. You will find some instances of persons participating in both tables. This is only natural and you have to make sure that your QlikView application use this data model correctly.