K
Karen
I need to query a single table over and over again and have a problem
with one of the links.
I'm using Access 2003 and the tables are MS SQL tables from our
business software.
The table is a bill of material table with a parent field and a
component field (there are other fields but they aren't important at
this time).
When I created the Select Query I added the table 6 times (each was
given an alias). I linked from the component of the first to the
parent of the second; from the component of the second to the parent of
the third and so on. I then ran the query for the parent of the first
equal to the item I was looking for.
The problem is that something is wrong with the link between the third
and fourth level. The query doesn't return parents in the fourth level
for all of the components in the third. It returns some of them but
not all of them. I don't see a pattern in the records that would
explain this. And the business software returns all of the components
in the product structure.
What is going on with this? Am I trying to do this type of link with
too many levels? Is there a better way to do this type of query?
Thanks for your help.
Karen
with one of the links.
I'm using Access 2003 and the tables are MS SQL tables from our
business software.
The table is a bill of material table with a parent field and a
component field (there are other fields but they aren't important at
this time).
When I created the Select Query I added the table 6 times (each was
given an alias). I linked from the component of the first to the
parent of the second; from the component of the second to the parent of
the third and so on. I then ran the query for the parent of the first
equal to the item I was looking for.
The problem is that something is wrong with the link between the third
and fourth level. The query doesn't return parents in the fourth level
for all of the components in the third. It returns some of them but
not all of them. I don't see a pattern in the records that would
explain this. And the business software returns all of the components
in the product structure.
What is going on with this? Am I trying to do this type of link with
too many levels? Is there a better way to do this type of query?
Thanks for your help.
Karen