Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all! Interesting question for you.
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!
Do you have a common field linking the tables together? If not, then you just can rename all your assignee name fields to [Asignee name].
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.