In my data model, I have multiple tables with different categories, tasks, subtasks etc. 1 person may be assigned to a category, and then assigned to a task, and a different person to a subtask. Right now each table has a [Assignee Name] field, so it looks like:
load
category_numer,
category_assignee_name
residentx;
load
task_number,
task_assignee_name
residenty;
And so on. What I want to do is for one person to be able to select their name and see the tasks, categories, and subtasks assigned to them. I can't figure out how to do a crosstable without creating a circular reference. Can this be done, front end or back end? Thanks!
Hi Vegar, yes, there is already a common field - each category has multiple tasks in it, so linked task ids, and similarly each set of subtasks are all attached to a task.
