Same Names without a Circular Reference - Help!

[Meghann_MacDonald]

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!

[Vegar]

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].

[Meghann_MacDonald]

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.