I used to be able to do this...about 2 years ago. It's amazing what you forget when you don't use the skills....
I have a table I'm trying to query information out of. Key fields are below:
I need to have a "record" in the query show both the description of itself, as well as it's parent. This is quick and dirty; I was hoping to use Dlookup directly in the query design. If there is no other way, I suppose I could create a temp table and look through the recordset in VBA and dump them into the temp table, but like I said; quick and dirty was the hope here, it's for my own use, and the tables aren't large 50-100 records is what I'll be pulling out when I use this.
reference "parent" description in hierarchical data table
I have a table I'm trying to query information out of. Key fields are below:
- RecNo (Key)
- ParentRecNo
- Description
I need to have a "record" in the query show both the description of itself, as well as it's parent. This is quick and dirty; I was hoping to use Dlookup directly in the query design. If there is no other way, I suppose I could create a temp table and look through the recordset in VBA and dump them into the temp table, but like I said; quick and dirty was the hope here, it's for my own use, and the tables aren't large 50-100 records is what I'll be pulling out when I use this.
