M
meghanwh
I have 6 tables that have the same data types in them. It is 6 levels
of information, but for each level the data collected is the same. So
for instance, in the tblMainGoals i have GoalID, GoalNumber and
GoalName. Then in the tblLevel2Goals I have Level2ID, Level2Number and
Level2Name, etc. There is also a field on tblLevel2Goals for GoalID,
which links artificially the two goals together (ie, all Level 2 Goals
are a subset of a main goal). Is there a way to create a query which
will simply list all the goals, without repeating them? Ideally I'd
like a query that had ID, Number, Name as the headings, and listed
goals from all the tables in one big list. I don't think this is
possible, but would love to hear that it is (especially for my client
who is positive that this can be done!) Thanks.
of information, but for each level the data collected is the same. So
for instance, in the tblMainGoals i have GoalID, GoalNumber and
GoalName. Then in the tblLevel2Goals I have Level2ID, Level2Number and
Level2Name, etc. There is also a field on tblLevel2Goals for GoalID,
which links artificially the two goals together (ie, all Level 2 Goals
are a subset of a main goal). Is there a way to create a query which
will simply list all the goals, without repeating them? Ideally I'd
like a query that had ID, Number, Name as the headings, and listed
goals from all the tables in one big list. I don't think this is
possible, but would love to hear that it is (especially for my client
who is positive that this can be done!) Thanks.