AnsweredAssumed Answered

Filtered Value List

Question asked by dvhoudek on Jan 30, 2012
Latest reply on Jan 30, 2012 by comment

I have a timesheet solution that needs to provide a list of tasks that an employee can choose from to record their time. Simple idea, however, the issue lies with wanting to show subtasks when all I have in allocations is project ID. My allocations table has year, month, empID and projectID. I have a relationship to the allocations table from the employee table based on empID, year and month (the individual chooses the month and year for which they are recording time). I have a relationship from allocations to subtasks based on projectID. I want to show the employee a complete list of subtasks based on their allocations for that month. Is there a way to do this? I think I'm just missing the key relationship I need to do this...


Thanks for any assistance!